Terminology differences in Sybase and Oracle:
- In Sybase it's a dataserver?. In Oracle, it's an instance?.
- In Sybase, it's a database?. In Oracle, it's a schema?.
- In Oracle, the schema is closely tied to the user, but in Sybase, the database isn't closely tied to the user.
- In Oracle, we have the tablespace?, which seem to be a construct that doesn't exist in Sybase. It seems as though the tablespace is the object that ties a physical storage device to a schema. Similar in Sybase as how there is a many-to-many table mapping sysdevices? to sysdatabases?.
- In Sybase, we have only TransactionLogs. In Oracle, we have RedoLogs? and the RollbackSegment?, which are two instantiations of the roll-forward and roll-back transaction logs.
| Edit -:- Attach -:- Ref-By -:- Printable -:- More |