System objects

From: Leigh Gold <intan_5ee_at_yahoo.com>
Date: Tue, 6 Nov 2001 16:25:52 -0700
Message-ID: <9s9rb1$f7o$1@news3.cadvision.com>

Hi there,

I am converting most of the tablespaces in my database to LMT, and on moving objects to the LMT, I noticed that there are some 'system' user owned objects with names like AQ$, SYS_,DEF$.

Is it okay to create a separate LMT tablespace for these objects and move them as how I would move a regular user objects? ie. 'alter table x move ' or 'alter index x rebuild'? How about lobindex and lobsegment objects?

Thanks for your help.

Leigh Received on Tue Nov 06 2001 - 17:25:52 CST