| Virusminus |
Posted: Apr 14, 2008 02:21:20 PM |
Total Post: 14
Joined: Jan, 2008
|
Hi Friends,
I need to refresh a database from another production database. Could anyone please tell me the proedure for that. I guess will be needing to do an export/import but I am not sure. So please could anyone advice me on this. Thanks
|
|
|
 fireit |
| Posted: Apr 14, 2008 02:38:11 PM |  |
|
Total Post: 23
Joined: Apr, 2007
|
if you want to take data from database A to database B, you can do an export/import operation. what do u want to do exactely?
|
|
|
|
|
| Virusminus |
| Posted: Apr 14, 2008 02:43:35 PM | |
|
Total Post: 14
Joined: Jan, 2008
|
Well in the request its just mentioned, refresh database 'A' located on server A from Database 'B' located on Server B. I guess they want me to import most recent data from DB A to DB B, but I want to know if anything else is done for refreshing a database.
|
|
|
|
|
| Murtuja |
| Posted: Apr 15, 2008 04:42:09 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
If you are on Oracle 10g then then you can use datapump for the same.It is same as exp / imp steps but performance wise datapump is more efficient.
|
|
|
|
|
| Virusminus |
| Posted: Apr 15, 2008 09:20:31 AM | |
|
Total Post: 14
Joined: Jan, 2008
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
