 Problem in Import & Export [message #311424] |
Fri, 04 April 2008 08:10  |
kiramatmarwat
Messages: 2
Registered: November 2006
Location: Islamabad
|
Junior Member |
|
|
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
