OraFAQ Forum: Server Utilities » Not able to export

Home » RDBMS Server » Server Utilities » Not able to export

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Not able to export [message #73189]

Thu, 26 February 2004 21:02

Neha
Messages: 20
Registered: July 2000

Junior Member

Hi

Its urgent

I have oracle 9i (9.2.0.1) as database on windows 2000 server platform.

I am getting errors mentioned below.

EXP-00008 -ORACLE Error 933 encountered

ORA-00933- SQL commond not properly ended

ORA-06512-at "SYS.DBMS-RULE_EXP_RL_INTERNAL" line 311

ORA-06512at "SYS.DBMS-RULE_EXP_RL_INTERNAL" line 142

ORA-06512-at line 1

EXP_00083:The previous problem occured when calling "SYS.DBMS_RULE_EXP-RULES.schema-info_exp

for export i give commond- "exp system consistent=y full=y file=f:/backup/export/ex.dmp log=f:/backup/log/lg.dmp"

for" Administrator Alert message:" like- add 4 mm dds to media pool" Remote storage/media pool.

I am not able to take full database backup so I have to take each user backup.
I have ran catalog.sql as well as catproc.sql also but still sam eproblem.
Suggest me what to do next.
Help me .
Neha

Report message to a moderator

Re: Not able to export [message #73191 is a reply to message #73189]

Fri, 27 February 2004 02:43

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

seems you have created some users/schema with double quoted name.
remove or rename them
and alwyas please post the exact error message.

the error is supposed to be
ORA-06512-at SYS.DBMS_RULE_EXP_RL_INTERNAL
and not
ORA-06512-at SYS.DBMS-RULE_EXP_RL_INTERNAL

Report message to a moderator

Re: Not able to export [message #73620 is a reply to message #73191]

Thu, 03 June 2004 23:07

Neha
Messages: 20
Registered: July 2000

Junior Member

I have oracle 9i rel2 on windows 2000 platform. While taking full exporti get tis error.after export backup following messages came:
EXP-00008 -ORACLE Error 933 encountered

ORA-00933- SQL commond not properly ended

ORA-06512-at "SYS.DBMS-RULE_EXP_RL_INTERNAL" line 311

ORA-06512at "SYS.DBMS-RULE_EXP_RL_INTERNAL" line 142

ORA-06512-at line 1

EXP_00083:The previous problem occured when calling "SYS.DBMS_RULE_EXP_RULES.schema-info_exp

for export i give commond- "exp system consistent=y full=y file=f:/backup/export/ex.dmp log=f:/backup/log/lg.dmp"

for" Administrator Alert message:" like- add 4 mm dds to media pool" Remote storage/media pool.

thnks and regards
Neha

Report message to a moderator

Previous Topic:	Full Import - In other words .
Next Topic:	date in the export file name

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 13:11:34 CDT 2024