DBMS_STREAMS_TABLESPACE_ADM.CLONE_TABLESPACES Fails With ORA-39002: Invalid Operation (Doc ID 463487.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.6 - Release: 10.1 to 11.1
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 10.1.0.2 to 11.1.0.6
Checked for bulk archive on 03-MAY-2011 by Zulaikha Z

Symptoms

Trying to clone a couple of Automatic Storage Management (ASM) tablespaces:

DECLARE
tbs_set DBMS_STREAMS_TABLESPACE_ADM.TABLESPACE_SET;
BEGIN
tbs_set(1) := 'TB1';
tbs_set(2) := 'TB2';
dbms_streams_tablespace_adm."_trace_level" := 5;
DBMS_STREAMS_TABLESPACE_ADM.CLONE_TABLESPACES(
tablespace_names => tbs_set,
tablespace_directory_object => 'DIR1',
log_file_directory_object => 'TESTLOG',
file_group_name => 'strmadmin.fg_TB1_TB2',
version_name => 'DIR1');
END;
/

and getting  ORA-39002: invalid operation


dbms_streams_tablespace_adm - datapump_job_name (SYS_EXPORT_TRANSPORTABLE_01)
dbms_streams_tablespace_adm - clone_detach_common called
dbms_streams_tablespace_adm - "_trace_level" (0)
dbms_streams_tablespace_adm - datapump_job_name ()
dbms_streams_tablespace_adm - tablespace_names(1) (TB1)
dbms_streams_tablespace_adm - tablespace_names(2) (TB2)
dbms_streams_tablespace_adm - dump_file.directory_object ("DIR1")
dbms_streams_tablespace_adm - dump_file.file_name (expdat12.dmp)
dbms_streams_tablespace_adm - tablespace_directory_objects(1) ("DIR1")
dbms_streams_tablespace_adm - destination_platform ()
dbms_streams_tablespace_adm - log_file.directory_object ("TESTLOG")
dbms_streams_tablespace_adm - log_file.file_name (expdat13.clg)
dbms_streams_tablespace_adm - keep_master (FALSE)
dbms_streams_tablespace_adm - copy_datafiles (TRUE)
dbms_streams_tablespace_adm - drop_tablespaces (FALSE)
dbms_streams_tablespace_adm - expr ( IN ('TB1','TB2'))
dbms_streams_tablespace_adm: clone_detach_common error
dbms_streams_tablespace_adm - SQLCODE (-39002)
dbms_streams_tablespace_adm error message is as follows
ORA-39002: invalid operation
...
dbms_streams_tablespace_adm: NULL dp
dbms_streams_tablespace_adm: invoke_clone error
dbms_streams_tablespace_adm - SQLCODE (-39002)
dbms_streams_tablespace_adm error message is as follows
ORA-39002: invalid operation
dbms_streams_tablespace_adm: clone_detach_fgr error
dbms_streams_tablespace_adm - SQLCODE (-39002)
dbms_streams_tablespace_adm error message is as follows
ORA-39002: invalid operation


All the parameters look fine, directory objects exist, permissions are correct and this works if non ASM.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms