chilu

 Profile Answers by chilu 

• Aug 28th, 2007

 

Transportable tablespaces are the fastest way for moving large volume of data between two oracle databases. We can use the transportable tablespaces feature to copy a set of tablespaces from one oracle database to another. Moving data using transportable tablespaces is much faster than performing either an export/import or unload/load the same data.

Mohammed Abdul Afroze

• Nov 7th, 2007

 

One of the new features with later versions of Oracle7 and all versions of Oracle8 and oracle9i is the read-only tablespace. A read-only tablespace, as its name implies, allows read-only access to its information. This is beneficial in several ways:

 Since we are only reading data, no redo or rollback is required for read-only tablespaces.

Read-only tablespaces only need to be backed up once after they are made read-only, then you can remove them from the backup plan.

The general procedure for making a tablespace read-only is:

1.Create the tablespace as a normal, permanent tablespace.

2.Populate the tablespace as you would a normal tablespace.

3.Once all data has been added to the tables in the tablespace, alter the tablespace to read-only.

Back up the tablespace using normal system backups.