Home » RDBMS Server » Server Utilities » Problem in Import & Export (Solaris)
icon9.gif  Problem in Import & Export [message #311424] Fri, 04 April 2008 08:10 Go to next message
Messages: 2
Registered: November 2006
Location: Islamabad
Junior Member
I have install oracle 10g Release 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

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
Re: Problem in Import & Export [message #311637 is a reply to message #311424] Sat, 05 April 2008 05:00 Go to previous message
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

copy and paste what you did.
Previous Topic: loading data in table by using sql loader
Next Topic: how to import 8i data in 10g
Goto Forum:

Current Time: Fri Aug 18 02:01:22 CDT 2017

Total time taken to generate the page: 0.17085 seconds