RE: Importing database issue

  • From: "Peter McLarty" <p.mclarty@xxxxxxxxxx>
  • To: <shastry17@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 11 Jul 2007 15:47:08 +1000

Hi Anant

You need to do a bit more study to get this one right try the ignore
parameter and the fromuser and touser parameter to import indiviudal
user objects in a schema, I would highly recommend a log parameter

See the
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm
for this 

Cheers

Peter  

-----Original Message-----
From: Anant [mailto:shastry17@xxxxxxxxx] 
Sent: Wednesday, 11 July 2007 02:34 PM
To: oracle-l
Subject: Importing database issue

Hi gurus,

I have an export dump of my database. Accidentally i dropped all the
users with cascade option. Now how can i import only the user info from
my export backup. Doing full import database( full=y) is throwing errors
having users doesnot exists .Does anyone have idea. Please suggest me.

Thanks,
Ann
--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


Other related posts: