| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Tool needed: getting data out of the database NOT using EXPORT
> problem. You'll need to check. If it's moving data regularly, Oracle8i has
> functionality like transportable tablespaces which might help. I've never
I doubt that this would help the original poster since one of the databases is Oracle 7 which does not support import or export of transportable tablespaces.
> In regards to export, have you used the direct=y option? My experience it
> improves speed. Also, to separate drive on database server from database
> files helps.
Using the DIRECT=Y option will certainly speed up the export, but will not help the import.
Another option to try would be to set up a database link to the remote database and then use an INSERT with SELECT statment. For instance, if there was a "remote_db" link to the remote database, then on the local system, one could issue:
INSERT INTO remote_table_at_remote_db SELECT * FROM local_table; Or you could go the other way, make the source database the remote one. Additionally, you could use the COPY command.
HTH,
Brian
 |
 |