| Schema level import [message #179601] |
Wed, 28 June 2006 03:21  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
Hi,
Is it possible to do schema level import using full database export,If so,if i set the
fromuser=system
touser=user1
Will it allow me to import only USER1 schema objects successfully?
Thanks,
Gajini
|
|
|
|
|
|
| Re: Schema level import [message #179666 is a reply to message #179601] |
Wed, 28 June 2006 06:11  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
Please Mahesh Rajendran advise me on this,because when i tried to do schema level import by setting,
fromuser=system
touser=(user1,user2)
It started to do full database import.
I searched in google,but i didn't get solution for this,
so advice me how to do a schema level import using full database export.
|
|
|
|
| Re: Schema level import [message #179670 is a reply to message #179666] |
Wed, 28 June 2006 06:28 |
 |
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Using your syntax, you'd import SYSTEM's objects into USER1's schema.
Documentation can be found here.
Shortly (and I hope it is correct),
IMP sys/its_password@database FILE=exp.dmp FROMUSER=some_user TOUSER=user1
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
