similar schema in the same database [message #49900] |
Sun, 17 February 2002 00:38 |
sriraj
Messages: 5 Registered: February 2002
|
Junior Member |
|
|
how to create similar schema in the same database with same data,procedures,constraints ,indexes,triggers etc.
i tried with exp and imp but it will not worked out properly.
sriraj
|
|
|
Re: similar schema in the same database [message #49922 is a reply to message #49900] |
Mon, 18 February 2002 09:15 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
It should work fine if you do something like this...
exp system/manager owner=scott file=scott.dmp log-scott.log
imp system/manager fromuser=scott touser=new_user file=scott.dmp log=imp_to_new_user.log
The code con't compile if it's been prefixed with the username like "select * from scott.emp". You need to edit those names to the new names. You can get all the code and DDL out of the dump file using the strings command in unix if that's the easiest way for you to edit the code.
strings scott.dmp > scott_ddl_and_code.sql
|
|
|