| Need help with schema export [message #476132] |
Tue, 21 September 2010 10:20  |
ateeqrahman786
Messages: 52
Registered: December 2009
Location: Hyderabad,India
|
Member |
|
|
Hi,
i want to do a schema export from Database A. There are hundreds of users under this schema.
I have to import this schema into other database say B.
My question's are:
1) Do i need to pre-create only schema user or all the users under it.
2) Will the schema export all the roles,procedures,packages,synonyms,funsctions and triggers?
Thanks,
|
|
|
|
| Re: Need help with schema export [message #476135 is a reply to message #476132] |
Tue, 21 September 2010 11:05  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:There are hundreds of users under this schema
This is meaningless in Oracle (unless you use very advanced features).
One schema is one user (account) and vice-versa.
So you have to precise your environment before we can answer.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
