| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Moving Outline Tables
yep --
by default, Oracle tries to recreate the tables in the same tablespace where
they came from. so you have to revoke all quota on the system tablespace as well
before importing. why don't you just use ALTER TABLE ... MOVE?
additions/corrections welcome,
kind regards,
Lex.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On
Behalf Of Connie Milliken
Sent: Friday, March 18, 2005 15:25
To: oracle-l_at_freelists.org
Subject: Moving Outline Tables
I am following the Oracle 9i Database Performance Guide for Moving Outline Tables and it isn't working. After importing the tables, they are still showing up as being in the system tablespace. Is there something missing here that I don't see?
Export the OL$, OL$HINTS, and OL$NODES tables: EXP OUTLN/OUTLN FILE = exp_file TABLES = 'OL$' 'OL$HINTS' 'OL$NODES'
Remove the previous OL$, OL$HINTS, and OL$NODES tables:
CONNECT OUTLN/outln_password;
DROP TABLE OL$;
CONNECT OUTLN/outln_password;
DROP TABLE OL$HINTS;
CONNECT OUTLN/outln_password;
DROP TABLE OL$NODES;
COMMIT;
Create a new tablespace for the tables:
CREATE TABLESPACE outln_ts
DATAFILE 'tspace.dat' SIZE 2MB
DEFAULT STORAGE (INITIAL 10KB NEXT 20KB
MINEXTENTS 1 MAXEXTENTS 999 PCTINCREASE 10) ONLINE;
Enter the following statement:
ALTER USER OUTLN DEFALUT TABLESPACE outln_ts;
Import the OL$, OL$HINTS, and OL$NODES tables:
IMP OUTLN/outln_password
FILE=exp_file TABLES = 'OL$' 'OL$HINTS' 'OL$NODES'
The IMPORT statement re-creates the OL$, OL$HINTS, and OL$NODES tables in the schema named OUTLN, but the schema now resides in a new tablespace called OUTLN_TS.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 18 2005 - 09:41:40 CST
 |
 |