locally managed temporary tablespace seems to be missing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: locally managed temporary tablespace seems to be missing

  1. #1
    Join Date
    Mar 2001
    Posts
    286
    After using RMAN to duplicate a database, everything is fine except the locally managed temporary tablespace seems to be missing. Look at the following query. Is this a bug?

    SQL> select * from dba_tablespaces where tablespace_name='BIG_TEMP';

    TABLESPACE_NAME INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING EXTENT_MAN ALLOCATIO PLU
    -------------------- -------------- ----------- ----------- ----------- ------------ ---------- --------- --------- --------- ---------- --------- ---
    BIG_TEMP 1048576 1048576 1 0 1048576 ONLINE TEMPORARY NOLOGGING LOCAL UNIFORM NO

    1 row selected.

    SQL> select * from DBA_TEMP_FILES;

    no rows selected

    SQL>

  2. #2
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    if it is a temp tablespace, oracle scarcely acknowledges temp files. since it seems to be in the DBA_TABLESPACES, do
    ALTER DATABASE CREATE DATAFILE 'blah' ...

    d.

  3. #3
    Join Date
    Mar 2001
    Posts
    286
    Here is the answer:

    ALTER TABLESPACE BIG_TEMP ADD TEMPFILE 'xxxxxxxxxxxxxx/big_temp01.dbf' SIZE 1073741824;

  4. #4
    Join Date
    Dec 2000
    Posts
    22
    the tempfile at temparory tablespace will be backup with rman, because the tempfile did not be recorded at control file.
    and don't rename and don't recovery. you can re-created the tempfile.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width