import [message #308999] |
Wed, 26 March 2008 03:49 |
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 #309313 is a reply to message #309010] |
Thu, 27 March 2008 01:55 |
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
|
|
|
|
|