Cannot skip USERS tablespace during duplicate database
Gurus,
why can't I skip USERS tablespace during cloning/duplicate target database to? I don't have any permanents objects in USERS. I am only trying to restore a user table which resides in TABLESPACE1 and I don't need all other non system tablespaces and I am skipping them including the USERS since user default tablespace is TABLESPACE1 .
sql statement: drop tablespace USERS including contents cascade constraints
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/25/2010 09:03:33
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 06/25/2010 09:03:33
RMAN-11003: failure during parse/execution of SQL statement: drop tablespace USERS including contents cascade constraints
why can't I skip USERS tablespace during cloning/duplicate target database to? I don't have any permanents objects in USERS. I am only trying to restore a user table which resides in TABLESPACE1 and I don't need all other non system tablespaces and I am skipping them including the USERS since user default tablespace is TABLESPACE1 .
sql statement: drop tablespace USERS including contents cascade constraints
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/25/2010 09:03:33
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 06/25/2010 09:03:33
RMAN-11003: failure during parse/execution of SQL statement: drop tablespace USERS including contents cascade constraints
0