Try creaing the table prior to the import. And use import parameter ignore=n Then drop the table.

-----Original Message-----
From: kazi [mailto:oracledba-ezmlmshield-x19915453.[Email address protected]
Sent: Wednesday, October 10, 2007 3:21 AM
To: LazyDBA Discussion
Subject: imp

Once again the same question.

I have 15 GB export of schema with hundreds of tables and other objects.
10 GB is occupied by a single table.

I want to import whole schema except that big table.

Any idea?

Regards KAzi


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page