| sasi |
Posted: Dec 15, 2005 09:21:48 AM |
Total Post: 59
Joined: Nov, 2005
|
HI,
i am having 2 Databases A & B. from A to B i want to export
entire schema from user to another user means A to B.plz reply
sarath |
|
|
 usha |
| Posted: Dec 15, 2005 03:53:38 PM |  |
|
Total Post: 2
Joined: Dec, 2005
|
Hi Venkat,
if you want to take full databse logical backup the follow the steps:-
1.shut down your database
2.Open it in restrict open mode i.e. sql>startup restrict open
3.perform full export by command sql> exp userid/password file='filename' full=y compress=y buffer=10000000
4.after export is complete open databse with command sql>alter system disable restricted session;
then import the database by command sql>imp userid/password file='exportfilename' buffer=10000000 full=y
All the best.........
|
|
|
|
|
| sasi |
| Posted: Jan 04, 2006 09:58:10 AM | |
|
Total Post: 59
Joined: Nov, 2005
|
|
|
|
|
| Ananth |
| Posted: Jan 16, 2006 05:12:44 AM | |
|
Total Post: 2
Joined: Jan, 2006
|
Hi
Entire Database or Entire Schema?
If Suppose if you want to copy a purticular Schema use FROMUSER in the EXP Utility.
|
|
|
|
|
| Ananth |
| Posted: Jan 16, 2006 05:14:19 AM | |
|
Total Post: 2
Joined: Jan, 2006
|
Sorry to say this ....
I cant understand your Question... Do you wanna to copy a Entire A database to B Database...
Or A.User to B database?
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
