Have you looked at ALTER TABLE...MOVE... ?
Ade
-Original Message-
Sent: 26 July 2001 18:51
To: [EMAIL PROTECTED]
Hi Group,
Please explain what I am doing wrong.
1) exp outln/outln@webprod mailto:outln/outln@webprod file=exp_file
tables = 'OL$' 'OL$HINTS'
2) Dropped the
Is it possible that the original user that the export was taken from was in
the system tablespace? Try doing a FROMUSER/TOUSER
kk
-Original Message-
George A.
Sent: Thursday, July 26, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L
Hi Group,
Please explain what I am doing wrong.
did you set the quota for the user to use the new tablespace and revoke the SYSTEM
tablespace?
If you did not try to control where they were allowed to go then the imp would put
them back where they came from.
Did you imp with IGNORE=Y?
just a thought.
ROR mª¿ªm
[EMAIL PROTECTED] 07/26/01
George:
I think you need to do a fromuser/touser export/import here.
Jon Walthour
--- Original Message ---
From: Rusnak, George A. [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 7/26/01 1:50:41 PM
Hi Group,
Please explain what I am doing wrong.
1)
://www.superpages.com
-Original Message-
From: Jon Walthour [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 2:31 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: moving tables to a different tablespace
George:
I think you need to do a fromuser/touser export/import here
Al,
Try doing an import with show=y, and check the tablespace in the DDL. You may need to
manually edit the DDL and change the tablespace from SYSTEM to OUTLN_TS. I have found
that a fromuser/touser will not force an override of the tablespace in the export
dump file.
Traci L. Rebman
Al,
In order to assure the tables end up in a tablespace other than the one from
which they originated, you'll have to create empty tables in the outln_ts
tablespace prior to the import (between step 4 5). Easiest way is to to a
import w/ indexfile=file_name, then edit and run this file.
Mike
I am sure someone answered already ... but
The tablespace is associated with the table create statement in the import
file. If you created the structures of the tables in the tablespace that
you wanted BEFORE you import the file and specify ignore errors then the
tables would be loaded into the
Hi Rusnak
I will not comment on that the tales is OUTLN's, but since you are using 8.1.7
then you can use alter table OL$ move tablespace x
Rusnak, George A. wrote:
Hi Group,
Please explain what I am doing wrong.
1) exp outln/outln@webprod mailto:outln/outln@webprod file=exp_file