Moving Outline Tables

From: Connie Milliken <cemail_219_at_hotmail.com>
Date: Fri, 18 Mar 2005 09:24:57 -0500
Message-ID: <BAY2-F2B463FA4020AAE3057A5BA54A0@phx.gbl>

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/

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 18 2005 - 09:28:29 CST