Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating a user which is an exact copy of an existing user in a databs

Status
Not open for further replies.
pjeypal

pjeypal

Programmer
Apr 17, 2006
36
US
Hi

For testing purposes i need to create a schema in an oracle database which is an exact copy of an existing schema in the same database. Which is the simplest way to do this? Is there any command

Thanks
PJ
 
Sort by date Sort by votes
Use the export and import commands, specifically the "fromuser=xx touser=yy" options on import.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
724
Andrzejek
Andrzejek
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
249
carp
carp
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
605
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
286
Livia8
Livia8
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
4K
carp
carp

Part and Inventory Search

Sponsor

Back
Top