Home » RDBMS Server » Server Utilities » Need help with schema export (win 10g)
Need help with schema export [message #476132] Tue, 21 September 2010 10:20 Go to next message
Messages: 52
Registered: December 2009
Location: Hyderabad,India
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?

Re: Need help with schema export [message #476135 is a reply to message #476132] Tue, 21 September 2010 11:05 Go to previous message
Michel Cadot
Messages: 65148
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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.

Previous Topic: Tablespace for Importing objects.
Next Topic: exp/imp of selected oracle view
Goto Forum:

Current Time: Mon Aug 21 13:01:23 CDT 2017

Total time taken to generate the page: 0.05454 seconds