So, I'm trying to export an oracle database(10.2) from EE to SE over a networklink.
It all works fine except that I'm hitting a limit. The database has 1335 schemas and it seems that I can't transfers these in one go. Not with the schemas parameter at least.
Currently I'm doing a full=n with schemas=(the schemas to export) as I'm not really sure what a full=y exclude=schemas:() will transfer. Seeing that I want a clean database.
I tried using cmdline impdp and a par file. But got the same error in both:
When trying 1000 schemas:
ORA-39001: invalid argument value
ORA-39071: Value for SCHEMAS is badly formed.
When trying 250:
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-39097: Data Pump job encountered unexpected error -6502
And when using 25 schemas it works fine.
The syntax is exactly the same, being built dynamicly.
As we can see it appears that the SCHEMAS variable has a length wich oracle can't handle.
Has anyone of you tried the same thing? Would you recommend going the easy way with full=y? Are you confident it doesn't transfer EE history or data.
Update:
An example of EE data imported when using the full=y on SE
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
ORA-00001: unique constraint (SYS.WRI$_ALERT_THRESHOLD_PK) violated
Failing sql is:
BEGIN
dbms_server_alert.set_threshold(9000,dbms_server_alert.operator_GE,'85',dbms_server_alert.operator_GE,'97',1,1,NULL,dbms_server_alert.object_type_TABLESPACE,'');COMMIT; END;
Which is AWR which is an enterprise feature.
Another is
ORA-29357: object AUTO_TASK_CONSUMER_GROUP already exists
Failing sql is:
BEGIN
dbms_resource_manager.create_consumer_group('AUTO_TASK_CONSUMER_GROUP','System maintenance task consumer group','ROUND-ROBIN');COMMIT; END;
which I believe is the resource manager and in it's turn enterprise feature.
Best Answer
Apparently a full=y is allowed.
Converting An Enterprise Edition Database To Standard Edition (Doc ID 139642.1)
So apparently all the EE DD objects are not transfered. Followed by dropping or excluding while exporting the EE schemas.