إنتقال للمحتوى

  • تسجيل الدخول عبر الفيس بوك تسجيل الدخول عبر تويتر Log In with LinkedIn Log In with Google      تسجيل دخول    
  • إنشاء حساب

صورة
- - - - -

مطلوب تعليمات تقوم بالتالي


1 رد (ردود) على هذا الموضوع

#1 ahmad_29607@svuonline.org

ahmad_29607@svuonline.org

    عضو

  • الأعضــاء
  • 1 مشاركة

تاريخ المشاركة 02 May 2011 - 05:39 AM

5. Write all the instructions needed to distribute the data files in the following manner:
1 Data file of the System tablespace on the D: drive
2 Data file of the Temp tablespace on the D: Drive
3 Data file of the Undo tablespace on the E: Drive


#2 ehab_sayed_abdallah

ehab_sayed_abdallah

    مشترك

  • الأعضــاء
  • 57 مشاركة
  • الاسم الأول:Ehab
  • اسم العائلة:Sayed
  • البـلـد: Country Flag
  • المنصب الحالي:Oracle Applications DBA

تاريخ المشاركة 03 May 2011 - 12:07 PM

You can rename and relocate datafiles of one or more tablespaces using ALTER DATABASE statement with the RENAME FILE clause. This option is the only choice if you want to rename or relocate datafiles of several tablespaces in one operation, or rename or relocate datafiles of the SYSTEM tablespace. If the database must remain open, consider instead the procedure outlined in the previous section.

To rename datafiles of several tablespaces in one operation or to rename datafiles of the SYSTEM tablespace, you must have the ALTER DATABASE system privilege.

To rename datafiles in multiple tablespaces, follow these steps.

Ensure that the database is mounted but closed.
Copy the datafiles to be renamed to their new locations and new names, using the operating system.
Use ALTER DATABASE to rename the file pointers in the database's control file.

For example, the following statement renames the datafiles/u02/oracle/rbdb1/sort01.dbf and /u02/oracle/rbdb1/user3.dbf to /u02/oracle/rbdb1/temp01.dbf and /u02/oracle/rbdb1/users03.dbf, respectively:

ALTER DATABASE
RENAME FILE '/u02/oracle/rbdb1/sort01.dbf',
'/u02/oracle/rbdb1/user3.dbf'
TO '/u02/oracle/rbdb1/temp01.dbf',
'/u02/oracle/rbdb1/users03.dbf;

The new files must already exist; this statement does not create the files. Also, always provide complete filenames (including their paths) to properly identify the old and new datafiles. In particular, specify the old datafile name exactly as it appears in the DBA_DATA_FILES view of the data dictionary.
Back up the database. After making any structural changes to a database, always perform an immediate and complete backup


Ehab Sayed Abdallah Labib
Oracle Applications DBA
ehab_sayed_abdallah@yahoo.com