EXP-00008: ORACLE error 933 encountered
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: EXP-00008: ORACLE error 933 encountered

  1. #1
    Join Date
    Apr 2009
    Posts
    51

    EXP-00008: ORACLE error 933 encountered

    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

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    I think "EXP-00008: ORACLE error 933 encountered" is related to a bad username -a username created with quotes and not to disk quota.

    Check DBA_USERS looking for a user that might...
    1- Have a space in the middle of the name
    2- Start with a number
    3- Start with a special character.

    A username like "JIM SMITH" would cause this issue - rename or drop the user.
    Last edited by PAVB; 02-27-2012 at 07:01 PM. Reason: typo
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width