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: Moving objects to a different tablespace using imp/exp

Re: Moving objects to a different tablespace using imp/exp

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 29 Jan 1999 15:11:10 -0600
Message-ID: <78t85e$p22$1@garnet.tc.umn.edu>


I have a script "ugly_DDL" that gets SQL from the Oracle exp/imp for tables, views, etc. then you can change the tablespace in the SQL or build in a default tablespace. The script will also strip the tablespace information off of the schema SQL if you want.

url: http://www.tc.umn.edu/~hause011/
--  



Steven Hauser, hause011_at_tc.umn.edu
Phone: (612)626-7135
Fax:   (612)625-6853

---------------------------------------------------------
Received on Fri Jan 29 1999 - 15:11:10 CST

Original text of this message

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