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

Exporting a tablespace

From: <srallapally_at_netscape.net>
Date: Thu, 25 Feb 1999 14:35:04 GMT
Message-ID: <7b3n2n$s8s$1@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 - 08:35:04 CST

Original text of this message

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