system shows error (exp 0008) at time of taking backup with export commond [message #72971] |
Sun, 28 December 2003 18:26 |
Neha
Messages: 20 Registered: July 2000
|
Junior Member |
|
|
Hi
system shows error (exp 0008) at time of taking backup with export commond
error is
exp 0008 orcle error 933 encountered.
ora 00933 sql command not properly ended.
ora-06512 at sys.dbms._rule_exp_rules_intrnal" line 311.
ora-06512 ar sys.dbms._rule_exp_rules line 142.
ora-06512 at line 1.
exp-00083 the previous problems occured when calling sys.dbms_rule_rules.schema_info_exp.
After showing these errors anotehr messages comes "Export terminated sucessfully with warnings"
Wheather such back-up is useful or not?
I have run catalog.sql and catproc.sql and then exported the database. But it didnot work.now exporting of full system is not being completed. It get stuck after a few seconds while exporting table definitions. Now we are taking export of each user seperately.
Suggest me what to do next?
Any help will be appreciated.
Thanks in advance.
Neha
|
|
|
|