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
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 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Export/Import Backup
Next Topic: Exporting DB schemas / tables without data
Goto Forum:
  


Current Time: Thu Mar 28 21:02:22 CDT 2024