Re: Strange Oracle setup

In article <1JGQ.4$3U2.325780_at_news.ipass.net>, David Sisk <davesisk_at_ipass.net> wrote:
>Congratulations on finding a customer who will give you repeat business!
>
>Dave
>
>Keith Matthews wrote in message <890424348snz_at_sweeney.demon.co.uk>...
>>As an inexperienced DBA I was recently asked to take on as DBA for a
>>special application. While it does work it is set up in a rather strange
 way
>>and I cannot see any reason for it.
>>
>>Firstly the usual synonyms for dba_tablespaces, all_tables, all_indexes
 etc.
>>are missing. So many of these are not present I suspect part of the setup
>>script has never been run.

Yes, the cat* scripts probably weren't run. That's ok in one sense, but you may be able to infer that things are in an undefined state wrt oracle versioning. I would suggest looking at the patch instructions at the oracle patch site, and tell the customer he shouldn't fall behind on versions. Scripts are in $ORACLE_HOME/rdbms/admin.

>>
>>Secondly the main application tables are owned by system, and the tables
 (but
>>not their indexes) are in the system tablespace.
>>
>>Can anyone think of a reason why (beyond laziness or sheer cussedness) this
>>should have been done.

Somebody goofed setting the default tablespaces when creating the schema. If there was an application script run to create this, the vendor is a dork. Follow the directions others have given you about tablespaces.

>>
>>Keith Matthews
>>
>
>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!