Re: Objects for Schema SYSTEM

look for the file

    ORACLE/HOME/.../dbs/sql.bsq

here you can find a description of all system-objects

perhaps try

    grep create.table sql.bsq > sysobjects.txt

than the file sysobjects.txt contains all create table & create tablespace statements with a short comment!

cheers
Rüdiger J. Schulz

mme schrieb:

> Hello everybody!
>
> Does anybody know how I can identify the standard/default objects in
> the SYSTEM Schema? I´ve run a script that created a very lot of
> additional objects in the schema SYSTEM and I wanna drop them
> now, but I don´t know which to delete and to keep.
>
> Please help me!
>
> regards
> /\/\attias
Received on Fri Feb 12 1999 - 04:34:33 CST