Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exporting a tablespace
Hi,
Yes it really does work and you do have the correct syntax.
Haven't done this for several years, but I don't remember any problems with the imports.
regards
Jerry Gitomer
srallapally_at_netscape.net wrote in message
<7b3n2n$s8s$1_at_nnrp1.dejanews.com>...
>Hello,
>Okay so exporting a tablespace sounds stupid..perhaps i should have said
>exporting the tables/indexes belonging to a tablespace. Now, I am trying
>to write a script which does this. My question is can i specify multiple
>table names in one line ? e.g suppose the tables belonging to tablespace
>ts_A are X,Y,Z then is
> exp80 username/passwd full=n consistent=y compress=y tables=(X,Y,Z)
>a valid command ?
>any DBA among you ever try this ? any forseeable pitfalls like while
importing
>it and such ?
>thanks
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Feb 25 1999 - 14:55:40 CST