Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2008
    Posts
    2

    Question Unanswered: Problem in Import Export

    I have install oracle 10g Release 10.1.0.3 also i have installed database vault.

    Conn to sqlplus datavault manager

    Create user app1 identfied by app1;
    grant connect to app1;

    Now connect sys as sysdba to sqlplus

    grant resource to app1;

    In short i will give him all athe grants...

    I make a realm of app1 'app1_realm'
    All the authozation is perfomed in realm.

    then i have add it to data dictionary realm as a participent.

    now when i export at table level, it will export the schema with out warnings ie successfully
    but when i export at schema level app1 then it will be exported but with errors.
    the error numbers are
    ora-39083
    ora-31625
    ora-01031

    these errors are raised with grants such as
    grant Unlimited tablespace to app1;
    grant connect to app1;
    grant resource to app1;
    grant exp_full_database to app1;
    grant imp_full_database to app1;


    and with other grants...
    Note that i have granted these grant to user app1



    Please help me

  2. #2
    Join Date
    Apr 2008
    Posts
    2
    I have install oracle 10g Release 10.1.0.3 also i have installed database vault.

    Conn to sqlplus datavault manager

    Create user app1 identfied by app1;
    grant connect to app1;

    Now connect sys as sysdba to sqlplus

    grant resource to app1;

    In short i will give him all athe grants...

    I make a realm of app1 'app1_realm'
    All the authozation is perfomed in realm.

    then i have add it to data dictionary realm as a participent.

    now when i export at table level, it will export the schema with out warnings ie successfully
    but when i export at schema level app1 then it will be exported but with errors.
    the error numbers are
    ora-39083
    ora-31625
    ora-01031

    these errors are raised with grants such as
    grant Unlimited tablespace to app1;
    grant connect to app1;
    grant resource to app1;
    grant exp_full_database to app1;
    grant imp_full_database to app1;


    and with other grants...
    Note that i have granted these grant to user app1



    Please help me

    __________________
    Best Regards,
    Kiramat Ullah

Posting Permissions

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