| copy data from one db to another [message #58044] |
Mon, 28 July 2003 08:41  |
sidd
Messages: 130
Registered: May 2003
|
Senior Member |
|
|
Is there any alternative to copy table from one db to another without using following
1. Export/Import, bcoz they don't let anyone to use their server Only way is through sqlplus
2. They don't let their data to wonder through network with dblink, so i cannot use dblink
3. i am using copy cmd which is freaking slow.
so there any other way left?? please guys
|
|
|
|
| Re: copy data from one db to another [message #58045 is a reply to message #58044] |
Mon, 28 July 2003 10:44  |
psmyth
Messages: 81
Registered: October 2002
|
Member |
|
|
on the face of it, I presume export/import is out of the question because they won't let you logon to the db server and run the export.
If that is a correct definition of the issue, then bear in mind that if you install the export/import utilities on the server you are running the 'copy' that is slow from, you should be able to do the export remotely.
Best to install a version of the utilities that matches the database version, but you shouldn't have any particular issues.
Good luck
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
