Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: export a tablespace ???? how ???
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
![]() |
![]() |