Re: dump table

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 8 Apr 2003 13:51:33 -0700
Message-ID: <2687bb95.0304081251.1fc558b7@posting.google.com>

"Michael L. Hostbaek" <carlos_at_pez.dk> wrote in message news:<slrnb95n8e.23fa.carlos_at_freebsdcluster.dk>...
> 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

Option 1, if the new machine has enough disk space and has the same version of Oracle on it or room to install the same version then export from the remote machine. All it takes is an tnsnames.ora entry to the old db.

Option 2, look up the tables= parameter of exp or optionally if you have several owners and no one owner takes more storage than is available the export owner option, owner=. (See Utilities manual, exp help=y)

HTH -- Mark D Powell -- Received on Tue Apr 08 2003 - 15:51:33 CDT