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.