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: Move schema and tablespace

Re: Move schema and tablespace

From: koert54 <koert54_at_nospam.com>
Date: Wed, 27 Feb 2002 18:10:03 GMT
Message-ID: <%h9f8.206288$rt4.21200@afrodite.telenet-ops.be>


Check out my pretty printer http://pretoria.sourceforge.net/ ... http://sourceforge.net/projects/pretoria for indexfiles - it's not perfect but good enough for the job

"godmann" <allanwtham_at_yahoo.com> wrote in message news:95cd51c.0202261937.4e5b995b_at_posting.google.com...
> Hi there,
>
> To import into different tablespace,
> do an import blah indexfile=blah.sql
>
> Modify the blah.sql. Change all the Create Table ...Tablespace xxx
> to yyy that you want. Run the blah.sql and import again with ignore=Y
>
>
> Allan W. Tham
> Oracle DBA
Received on Wed Feb 27 2002 - 12:10:03 CST

Original text of this message

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