OraFAQ Forum: Server Utilities » Exclude tables in my schema import

Home » RDBMS Server » Server Utilities » Exclude tables in my schema import (oracle 9.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Exclude tables in my schema import [message #393943]

Wed, 25 March 2009 02:11

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

Report message to a moderator

Re: Exclude tables in my schema import [message #393944 is a reply to message #393943]

Wed, 25 March 2009 02:18

Michel Cadot
Messages: 68647
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

babuknb
Messages: 1736
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

Report message to a moderator

Re: Exclude tables in my schema import [message #394094 is a reply to message #393943]

Wed, 25 March 2009 12:41

joy_division
Messages: 4963
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 22:02:10 CDT 2024