Re: system tables

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

ivo zaenen <ivzae_at_gengenp.rug.ac.be> schreef in berichtnieuws 3933D466.D5D793FE_at_gengenp.rug.ac.be...
> We recently moved from Sybase to Oracle8 . In converting the
> applications I have the following problem:
> when I make a new database and transfer the tables of my application to
> it I see together with my application specific tables also tables that
> are apparently system related (like mdsys.mdtab,ctxsys.* ,etc.) .
> How can I get rid of these system specific tables since they are
> particularly annoying when I try to synchronize(reverse engineer) my
> application- tables with my modelling tool ( these are then treated as
> if they belong to the application and are transfered to my model also)
> Thanks in advance for your help
>
>
> Ivo Zaenen
> Lab Molecular Genetics
> University Ghent
> Belgium
>
Received on Tue May 30 2000 - 00:00:00 CDT