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: Exporting a tablespace

Re: Exporting a tablespace

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: Thu, 25 Feb 1999 20:55:40 GMT
Message-ID: <gNiB2.35$Rh7.144056@client.news.psi.net>


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

Original text of this message

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