Re: switch sybase to oracle

On 11 Sep 1998 19:58:42 GMT, Paul Chang <pch_at_pinnacle.> wrote:
>
>In our current sybase system, we have 4 to 5 databases.
>All objects are owned by sa.
>some tables have relationship resided in different db.
>Thus we have triggers doing RI checking cross db.
>
>Once we migration to Oracle, we need to resign the physical structure?

You don't have to, but probably want to unless you have an extremely simple db.

>
>I mean each db in sybase correcponds to one tablespace in Oracle?

That could be one way to go, but isn't necessary. A table could have it's data in one tablespace and it's index in another, for instance. Hot backups are tablespace oriented, however.

>
>Does Oracle allow different table in different tablespace having
>relationship? Can trigger do RI checking across tablespace?

I've found most people find thinking of Oracle schemas equivalent to Sybase databases the most sensible. The Oracle concept of database is more all-inclusive than some others.

>
>thanks,
>
>Paul.
>

jg

-- 
These opinions are my own and not necessarily those of Information Quest or 
Pebble In The Sky http://www.informationquest.com mailto:jgarry_at_nospameiq.com
http://ourworld.compuserve.com/homepages/joel_garry   Remove nospam to reply.  
mailto:joel_garry_at_compuserve.nospam.com  "See your DBA?"  I AM the @#%*& DBA!