Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: dump table

Re: dump table

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Tue, 08 Apr 2003 08:03:16 -0700
Message-ID: <WwBka.2$%X5.1@fed1read03>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US