Migrate to Local
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Migrate to Local

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    Migrate to Local

    Hi All

    DBA before me left the company. He created the following tablespaces
    I am trying to migrate tablespaces from DMT to LMT

    TABLESPACE_NAME
    -----------
    SYSTEM
    TOOLS
    RBS
    USERS
    TEMP
    INDX
    INDX_TEMP
    HL_INDX_ORG
    RBS_TMP INDX_BIG RBS2
    INDX_MED INDX_SMALL USERS_TEMP
    14 rows selected.

    The following shows USERS tablespace with many file_id.
    SQL> SELECT FILE_ID, TABLESPACE_NAME FROM DBA_DATA_FILES
    TABLESPACE_NAME='USERS';

    FILE_ID TABLESPACE_NAME
    ---------- ------------------------------
    11 USERS
    5 USERS
    7 USERS
    8 USERS
    17 USERS
    22 USERS
    25 USERS
    27 USERS
    29 USERS
    30 USERS
    34 USERS

    QUESTION?
    Consider the above USERS' tablespace file_id,s can I migrate with the following without mentioning the file_id#?

    EXEC DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL(tablespace_name =>'RBS', rfno => 2);

    Please advise
    Thanks
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    just supply the tablespace name, ignore the rfno.

    Or better still create a new LMT tablespace and move your objects

  3. #3
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Thanks davey
    I will be creating new ones in the new database;
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

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