Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Halp!!! Import data: new machines with three disks and different table spaces from export
Since you are dealing with a small number of tables, the fastest way would be to
create the database with the desired tablespaces and then do an import with
indexfile=create.sql. This will create a SQL script with the create index
commands and also the create table commands (but these will be commented out).
Take the REM out of the beginning of the create table lines and alter the
tablespace for the tables to the tablespace you want. Run the create.sql script
and then do an import with ignore=y to ignore object creation errors. Drop me a
line if you need more details.
bonanos_at_yahoo.com wrote:
> Amigos
>
> I have a new machine, with three different physical disks.
>
> I also have an existing machine with only 2 disks and only 1 tablepsace for
> the data and another for indexes.
>
> Now I want to change that to 2 different tablespaces for data and 1 for the
> indexes. What is the easiest way of accomplishing this task. There are a total
> of about 40 tables with a few big ones and about double that in indexes
>
> Any help will be greatly appreciated ! :-)
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Oct 02 1998 - 13:01:49 CDT