Re: Tablespace's health

Stefano:
It would appear that you are storing your user tables in the SYSTEM tablespace. This is not a good practice. If at all possible you need to do the following:

1. Export the owner of the user tables.
2. Create a new instance of oracle with the system tablespace located other than in the $ORACLE_HOME path, same with control files, redo-log files, temporary tablespace data files, then create a separate tablespace for the user tables, using a name that reflects the owner of the tables in the file name i.e. /db02/ORACLE/dev1/owner_01.dbf with a size of 40 Mb
3. Import the export taken in step 1.

This should be sufficient for the initial tables and the new ones,

If you have any other questions please e-mail me. Thanks..
Perry

-- 
|~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|


| trimblep_at_aztec.asu.edu | Opinions expressed   |


| Oracle DBA >1987       | are only my own.     |


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~