Home » RDBMS Server » Server Utilities » EXP-00008: ORACLE error 933 encountered (oracle database 9.2.0.1.0 on windows 2003 server)
EXP-00008: ORACLE error 933 encountered [message #545049] Mon, 27 February 2012 00:56 Go to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member

Hi all,

every day we have full backup of oracle database (9.2.0.1.0) on windows 2003 server. since couple of days
i am getting following below error. i checked the solutions on google which talk about user quotas , i checked the user quotas by which i am taking
full backup it is unlimited , even i tried another user which also have umlimited quota on its default tablespace still i getting below
error, any suggestions ,openion will be highly appreciated. thanks


E:\backup>exp system/manager file=full26022012.dmp log=full26022012.log full=y statistics=none

EXP-00008: ORACLE error 933 encountered
ORA-00933: SQL command not properly ended
ORA-06512: at "SYS.DBMS_RULE_EXP_RL_INTERNAL", line 311
ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 142
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp



even i go for full export by any other user which has full export privilege & unlimited quotas. i getting the same error.

E:\backup>exp username/password file=full26022012.dmp log=full26022012.log full=y statistics=none

EXP-00008: ORACLE error 933 encountered
ORA-00933: SQL command not properly ended
ORA-06512: at "SYS.DBMS_RULE_EXP_RL_INTERNAL", line 311
ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 142
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp


Re: EXP-00008: ORACLE error 933 encountered [message #545058 is a reply to message #545049] Mon, 27 February 2012 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 66567
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
since couple of days i am getting following below error.


What has changed during this period?

Regards
Michel
Re: EXP-00008: ORACLE error 933 encountered [message #545063 is a reply to message #545058] Mon, 27 February 2012 01:39 Go to previous messageGo to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member



H Michael,

Nothing change has been done during this period.
Re: EXP-00008: ORACLE error 933 encountered [message #545065 is a reply to message #545063] Mon, 27 February 2012 01:51 Go to previous messageGo to next message
Michel Cadot
Messages: 66567
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Obviously this is not true.

Regards
Michel
Re: EXP-00008: ORACLE error 933 encountered [message #545066 is a reply to message #545063] Mon, 27 February 2012 01:51 Go to previous message
Littlefoot
Messages: 21501
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is the 9.2.0.1.0 database you use. Is EXP's version the same, or do you use another one? If so, which one?
Previous Topic: Version of exp and imp utilities
Next Topic: database import problem
Goto Forum:
  


Current Time: Mon Sep 23 08:52:23 CDT 2019