Home » RDBMS Server » Server Utilities » Exclude tables in my schema import (oracle 9.2)
Exclude tables in my schema import [message #393943] Wed, 25 March 2009 02:11 Go to next message
ajaysharma2907
Messages: 14
Registered: June 2008
Location: Delhi
Junior Member

Dear Sir,

I have to make an import of a big schema, in which i want to exclude five big tables from the whole schema.i have a total of 614 tables.

Any idea how to go about it.

Regards,

Ajay Sharma
Re: Exclude tables in my schema import [message #393944 is a reply to message #393943] Wed, 25 March 2009 02:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This has been asked and answered about one zillion times since exp/imp was introduced.
Search BEFORE posting.

Regards
Michel

[Updated on: Wed, 25 March 2009 02:18]

Report message to a moderator

Re: Exclude tables in my schema import [message #393971 is a reply to message #393944] Wed, 25 March 2009 04:26 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

In Oracle 9i, There is NO specific exclude parameter. But if you want you can use TABLES parameter


D:\>imp ram/ram file=D:\babu.dmp tables=tst

Import: Release 10.2.0.1.0 - Production on Wed Mar 25 14:53:54 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

Export file created by EXPORT:V10.02.01 via conventional path

Warning: the objects were exported by BABU, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing BABU's objects into RAM
. importing BABU's objects into RAM
. . importing table                          "TST"          2 rows imported
Import terminated successfully without warnings.


Babu
Re: Exclude tables in my schema import [message #394094 is a reply to message #393943] Wed, 25 March 2009 12:41 Go to previous message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
ajaysharma2907 wrote on Wed, 25 March 2009 03:11

Any idea how to go about it.



If it's a new schema, just precreate the 5 tables and choose to not ignore existing objects.

If not, create dummy tables with the same name that do not match the structure. This is not the best method, but it works.

[edit] semantical fix

[Updated on: Wed, 25 March 2009 12:43]

Report message to a moderator

Previous Topic: EXP-00008-
Next Topic: import excel csv file into database
Goto Forum:
  


Current Time: Fri Dec 09 01:50:31 CST 2016

Total time taken to generate the page: 0.05341 seconds