RE: Importing database issue

From: Peter McLarty <p.mclarty_at_cqu.edu.au>
Date: Wed, 11 Jul 2007 15:47:08 +1000
Message-ID: <27AA2E9CA7A0C44283BC1E9B00086AA90713D3CC@UNIMAIL.staff.ad.cqu.edu.au>

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_at_gmail.com] 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
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jul 11 2007 - 00:47:08 CDT