Home » RDBMS Server » Backup & Recovery » system shows error (exp 0008) at time of taking backup with export commond
system shows error (exp 0008) at time of taking backup with export commond [message #72971] Sun, 28 December 2003 18:26 Go to next message
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
Re: system shows error (exp 0008) at time of taking backup with export commond [message #72972 is a reply to message #72971] Sun, 28 December 2003 20:52 Go to previous message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
Hi,

I wouldn't trust such an export, even though you might be able to re-import some of it.

Are you exporting the database with the same version's export utility? You can expect strange errors when the DB and exp versions do not match.

Best regards.

Frank
Previous Topic: "RMAN Recovery Catalog Backup w/ NOCATALOG" to Tape.
Next Topic: RMAN memory utilization
Goto Forum:
  


Current Time: Sat Nov 23 22:57:26 CST 2024