Re: Strange Oracle setup

Keith Matthews wrote:

> 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.
>
> 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

maybe laziness but more likely inexperience.

> should have been done.

it should not be done this way.

Take some time to design a more reasonable layout, a backup and recovery scheme, a fallback plan and then plan on a night (or weekend) to implement.

is the instance a 24x7 or are you in luck with something less critical?

>
>
> Keith Matthews

--

Steve

=========================================
              Steve Emmett
=========================================
"A mind that is stretched to a new idea
 never returns to its original dimension"
=========================================