Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: system tables

Re: system tables

From: ivo zaenen <ivzae_at_gengenp.rug.ac.be>
Date: 2000/05/31
Message-ID: <39353853.7EA87ECF@gengenp.rug.ac.be>#1/1

Thank you for your response ( I will read the Oracle concepts manual) , but maybe did I not make me
clear enough. When I make a user/scheme I do see only my application related tables in it when I look
at it in the Oracle environment(schema manager), it is when I look at it in my development environments (Delphi, InfoModeler) that I see all the other tables.

regards,

Ivo Zaenen

Sybrand Bakker wrote:

> You need to understand the structural difference between Sybase and Oracle
> first:
> The Sybase 'database' concept can be equated with a 'schema' in Oracle.
> Apparently you are loading everything in the Oracle sys or system account,
> otherwise you wouldn't have asked this question.
> To answer it:
> No, you can't *get rid of them* or you would *screw up database
> functionality completely*, you need to use your own schemas to transport the
> data to.
> Please try to read the Oracle concepts manual, my educated guess is you
> didn't.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
>
Received on Wed May 31 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US