[email protected] بتاريخ: 2 مايو 2011 تقديم بلاغ مشاركة بتاريخ: 2 مايو 2011 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: drive2 Data file of the Temp tablespace on the D: Drive3 Data file of the Undo tablespace on the E: Drive اقتباس رابط هذا التعليق شارك المزيد من خيارات المشاركة
ehab_sayed_abdallah بتاريخ: 3 مايو 2011 تقديم بلاغ مشاركة بتاريخ: 3 مايو 2011 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 DATABASERENAME 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 اقتباس رابط هذا التعليق شارك المزيد من خيارات المشاركة
Recommended Posts
انضم إلى المناقشة
يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.