-
Here is the problem, I do not think you need a full import.
Why don't you explain a little more about what you are trying to accomplish?... you are trying to move data from database-1 to database-2 in a daily basis, isn't it?
I'm not in any way endorsing your exp/imp strategy but in your scenario I would move only the schema -or schemas that own the data I want to move.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Even when i am doing from schema to schema its giving errors:
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(2104,dbms_server_alert.operator_GT,'1200',d"
"bms_server_alert.operator_NONE,'',1,3,'asiprod',dbms_server_alert.object_ty"
"pe_SYSTEM,'');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 93:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
or
ora: 00001 unique constraints.....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|