Simple Exp/Imp Question

Hi All,

We currently have a simple test server running on a single drive.

We got a new Compaq server with 3 drive (RAID 5, 3+1 Parity) and would like to perform a full migration from the old to the new server.
(Oracle 8.15 to Oracle 8.16 )

(1) The source drive is d:/ when performing a full export and the target
drive
will be e:/ when performing a full import. Is there a parameter that I can specify
to change the target path to e:/ instead of defaulting to d:/ when using Oracle imp/exp
utilities ?

(2) Since this is a test server, it comprise of more than 70 users
sharing about 30 different tablespaces. Is there a parameter that I can specify to import the user into a designated new tablespace on a new drive path. ie.

(a) Sys or System User to System Tablespace (e:/)
(b) Non Sys or System user to User Tablespace (f:/)
(c) All indexes to Index Tablespace (g:/)

(3) While performing a full database import, wouldn't the process for the
system objects be skipped as the system objects already exist on the target ?
If so, is there a way to import all user schema avoid the sys and system tables during a full import.

Any advise would be greatly appreciated. Thanks in advance and you have a pleasant evening.

Kenny- Received on Sun Aug 27 2000 - 02:30:43 CDT