Error while exporting
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Error while exporting

  1. #1
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339

    Error while exporting

    Hi All,

    i am getting the below error while exporting full database.kindly suggest a solution.

    EXP-00008: ORACLE error 1950 encountered
    ORA-01950: no privileges on tablespace 'SNASLOG_DATA'
    ORA-06512: at "SYS.DBMS_RULE_EXP_RL_INTERNAL", line 328
    ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 147
    ORA-06512: at line 1
    EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp
    . exporting cluster definitions
    Last edited by gopu_g; 11-10-2009 at 10:44 AM.
    Thanks/Gopu

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    It looks to me the user running export either has no privileges on tablespace SNASLOG_DATA or tablespace SNASLOG_DATA is full or user's quota in such tablespace got exausted. I would go with first one.

    Remember, export do creates a table on default tablespace.
    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.

  3. #3
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339
    Pavb,

    Thanks for your answer.
    we have enough space in the tablespace, i have given the grants and restarted the the export. Then also it is throwing the same error.

    TABLESPACE_NAME Tot size MB Tot Free MB %FREE %USED
    ------------------------- ----------- ----------- ---------- ----------
    SNASLOG_DATA 16384 9671 59 41
    Last edited by gopu_g; 11-10-2009 at 12:40 PM.
    Thanks/Gopu

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Try this ...

    alter user USER_RUNNING_EXP quota unlimited on SNASLOG_DATA;

    where: USER_RUNNING_EXP is the account running exp

    ... then try export again.
    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.

  5. #5
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339
    The export is running from the "system" user. I have granted like you said before and after.Then also i can see the error in the export log.
    Thanks/Gopu

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Time to open a TAR with Oracle.
    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.

  7. #7
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339
    Yeah PAVB, going to raise SR. Once it is solved i will let u know.
    thanks for all the support
    Thanks/Gopu

  8. #8
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339
    Hi Pavb,

    THE ISSUE IS FIXED

    ERROR

    ------

    EXP-00008: ORACLE error 1950 encountered
    ORA-01950: no privileges on tablespace 'SNASLOG_DATA'
    ORA-06512: at "SYS.DBMS_RULE_EXP_RL_INTERNAL", line 328
    ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 147
    ORA-06512: at line 1
    EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp
    . exporting cluster definitions

    EXP-00008: ORACLE error 1950 encountered
    ORA-01950: no privileges on tablespace 'SNASRPT_DATA'
    ORA-06512: at "SYS.DBMS_RULE_EXP_RL_INTERNAL", line 328
    ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 147
    ORA-06512: at line 1
    EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp
    . exporting cluster definitions



    CAUSE
    -----

    Trace the export by setting this.

    SQL> ALTER SYSTEM SET EVENTS '1950 TRACE NAME ERRORSTACK LEVEL 4';



    The generated trace file showed:

    ORA-01950: no privileges on tablespace 'SNASLOG_DATA'
    Current SQL statement for this session:

    create table "SNASLOGAPP".re$action_imp_tab(owner varchar2(30), name varchar2(30), action sys.re$nv_node)
    ----- PL/SQL Call Stack -----
    object line object
    handle number name
    0x72b37bd8 328 package body SYS.DBMS_RULE_EXP_RL_INTERNAL
    0x89d77c00 147 package body SYS.DBMS_RULE_EXP_RULES
    0x99d00e18 1 anonymous block

    ORA-01950: no privileges on tablespace 'SNASRPT_DATA'
    Current SQL statement for this session:
    create table "SNASRPTAPP".re$action_imp_tab(owner varchar2(30), name varchar2(30), action sys.re$nv_node)
    ----- PL/SQL Call Stack -----
    object line object
    handle number name
    0x72b37bd8 328 package body SYS.DBMS_RULE_EXP_RL_INTERNAL
    0x89d77c00 147 package body SYS.DBMS_RULE_EXP_RULES

    SOLUTION
    --------

    alter user SNASLOGAPP quota unlimited on SNASLOG_DATA;
    alter user SNASRPTAPP quota unlimited on SNASRPT_DATA;

    And started the export.

    . exporting dimensions
    . exporting post-schema procedural objects and actions
    . exporting user history table
    . exporting default and system auditing options
    . exporting statistics
    Export terminated successfully without warnings.
    Last edited by gopu_g; 11-30-2009 at 03:13 PM.
    Thanks/Gopu

  9. #9
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Glad you got it fix.
    Solution looks pretty much like the one I suggested on Nov 10th, isn't it?
    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.

  10. #10
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339
    yes.. but, the mistake we did is we have granted the privs to the system user.
    When i traced the export then only came to know that for which user the privs are missing.
    Thanks for your help MAN.
    Thanks/Gopu

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