Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: dump table
Michael L. Hostbaek wrote:
> Group,
>
> I am trying to move all contents of one database from one server to
> another. I am not able to make a complete dump/export on the old server
> due to lack of space on drive.
>
> So, I'd like to know if there is some way of 'dumping' one table at a
> time ?
>
> Thanks
>
One way would be to use a DB_LINK between the two DBs.
CREATE TABLE <TABLE_NAME> AS SELECT * FROM <TABLE_NAME>@OLD_DB; Received on Tue Apr 08 2003 - 10:03:16 CDT