Moving Outline Tables
- From: "Connie Milliken" <cemail_219@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 18 Mar 2005 09:24:57 -0500
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.
_________________________________________________________________
Don?t just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
