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: 68510
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: Export/Import Backup
Next Topic: Exporting DB schemas / tables without data
Goto Forum:

Current Time: Sun Oct 01 16:41:10 CDT 2023