Home » RDBMS Server » Server Utilities » import (oracle 8 or oracle 10g on windows or linux)
import [message #308999] Wed, 26 March 2008 03:49 Go to next message
tnagarjun
Messages: 6
Registered: November 2007
Location: HYDERABAD
Junior Member
Good Day everybody,

Can i know please , how to import some of tables based on certain criteria (ex. based on table names ) while using schema level import ( ex. using " FROMUSER = TOUSER = " option)

thanking you
T.nagarjun
email: tnagarjun@rediff.com

[Updated on: Wed, 26 March 2008 04:00] by Moderator

Report message to a moderator

Re: import [message #309010 is a reply to message #308999] Wed, 26 March 2008 04:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can use TABLES list along with FROMUSER/TOUSER.

Regards
Michel
Re: import [message #309306 is a reply to message #309010] Thu, 27 March 2008 01:45 Go to previous messageGo to next message
tnagarjun
Messages: 6
Registered: November 2007
Location: HYDERABAD
Junior Member

Good Day Michel,

I wil try it and get back to you.

Nagarjun
tnagarjun@rediff.com
Re: import [message #309313 is a reply to message #309010] Thu, 27 March 2008 01:55 Go to previous messageGo to next message
tnagarjun
Messages: 6
Registered: November 2007
Location: HYDERABAD
Junior Member
good day Michel,

Its ok Thank you for response, but I want to eliminate tables while importing while using wild card chars.
For example :
User1 has tables like EMP, DEPT, SALARY , TRANSACTION AND TICKET, HIST_TICKET, HIST_TRANSACTION , HIST_EMP.
Now want to import only tables not having part or full word
like 'HIST' . In the above example I need only EMP, DEPT, SALARY, TRANSACTION AND TICKET only. And exported user was User2
and now I want to import into user4 by connecting as User6.

nagarjun
Re: import [message #309331 is a reply to message #309313] Thu, 27 March 2008 02:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I want to eliminate tables while importing while using wild card chars.

You can't, you have to list the tables.

Regards
Michel
Re: import [message #309608 is a reply to message #309331] Fri, 28 March 2008 02:35 Go to previous message
tnagarjun
Messages: 6
Registered: November 2007
Location: HYDERABAD
Junior Member

Good Day Michel,

Its ok and thank you for your reply.

Nagarjun
Previous Topic: export and import
Next Topic: Moving tables between schemas using command line
Goto Forum:
  


Current Time: Sun Dec 11 04:14:57 CST 2016

Total time taken to generate the page: 0.03822 seconds