| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Drop & recreate temp tablespace while creating logical stby db
Dear List,
Is there any particular reason why do we have to drop and recreate temporary tablespace while creating logical stby db?
The document says as below..
4.2.16 Create a New Temporary File for the Logical Standby Database The temporary files, which were included as a part of the closed backup operation on the primary database, are not viable on the logical standby database. (It is not necessary to copy temporary files from the primary database to the logical standby database.)
To identify and drop obsolete temporary files, perform the following steps on the logical standby database.
Step 1 Identify the current temporary files. On the logical standby database, issue the following query to identify the current temporary files for the standby database:
SQL> SELECT * FROM V$TEMPFILE;
no rows selected
If this query returns "no rows selected" as shown in the example, skip step 2 and go to step 3.
Step 2 Drop each current temporary file from the standby database. Drop each current temporary file from the standby database, as follows:
SQL> ALTER DATABASE TEMPFILE 'tempfilename' DROP;
 |
 |