Re: tips on moving oracle to new machine

First, import will house a table (or other segment) in exactly the same tablespace as it came from. If there is no identical tablespace, then it will house it in the default tablespace of the person doing the import. If there is no default tablespace, it will go to SYSTEM tablespace (ugh!).

Theoretically, you could import at the table level having carefully changed your default tablespace beforehand, and thus accomplish a change in tablespace, but this is clunky to say the least.

The move tablespace is *almost* worth upgrading to 8i on its own, and it certainly has nothing to do with index-organised tablespaces per se.

You might want to consider the INDEXFILE option of the import command: it create a text file which contains the SQL statements necessary to re-create indexes and tables. The create table statements are all remm'ed out, but it's a quick fix to edit the file and remove the rems. You then have a script that will reconstruct all tables and indexes (assuming you specified full=y). It can be edited to make the 'tablespace' bits refer to any tablespace you fancy.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



<gdas_at_my-deja.com> wrote in message news:8q9k4f$l3d$1_at_nnrp1.deja.com...


> In article <39c835e4$1_at_news.iprimus.com.au>,

>   "Howard J. Rogers" <howardjr_at_www.com> wrote:

> > Version of Oracle would help.

> >

> > If you have 8i, the 'move tablespace' command comes in particularly

 handy.


> >

> > Regards

> > HJR

>

> So you are saying that there is no way to accomplish this on the import

> and I just have to import the data as is and find a way to move things

> around manually? in which case the move tablespace command might work

> (I am using 8i, but the documentation seems to imply this command only

> works with index organized tables.  My tables are not of this type),

> but I will give it a shot.

>

> Just wanted to make sure there weren't any tricks in the import.

>

> Thanks for the help,

> Gavin

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.