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

Home -> Community -> Usenet -> c.d.o.server -> Re: export a tablespace ???? how ???

Re: export a tablespace ???? how ???

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Wed, 28 Mar 2001 13:07:47 GMT
Message-ID: <3ac1e08f.11975185@news-server>

On Tue, 27 Mar 2001 16:45:50 -0500, Liz Reen <lizr_at_geologist.com> wrote:

>
>He could find out what tables are in the tablespace and just export them.
>

Absolutely. But in many versions of O, there is a small limit to the length of string that can be specified in the TABLES parameter, particularly if you have to specify the owner as well. When that limit is hit, you gotta do multiple exports and it starts to get messy. Not to mention you gotta find the limit first by trial and error.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Wed Mar 28 2001 - 07:07:47 CST

Original text of this message

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