Home » RDBMS Server » Server Administration » Urgent - To create duplicate schema with different name and with all objects and
Urgent - To create duplicate schema with different name and with all objects and [message #63021] Thu, 02 September 2004 07:45 Go to next message
Swamy
Messages: 78
Registered: June 2002
Member
Is there any (simple and easy way) way to create a duplicate schema on the same database with different name? This schema should be exactly replica for the original one, including with all the data. I appreciate in advance for any help in this regard.

Report message to a moderator

Re: Urgent - To create duplicate schema with different name and with all objects [message #63023 is a reply to message #63021] Thu, 02 September 2004 08:12 Go to previous message
Ben
Messages: 48
Registered: January 2000
Member
Simply
1. create a new user
2. take export of the existing user
3. import into new user

done !

Report message to a moderator

Previous Topic: creating tables
Next Topic: Createing a second DB on a single install of Oracle 8i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 08:21:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.