Re: MS SQL Server -> Oracle RE: TIMESTAMP

ROWID is an arbitary numbering scheme. No sequencing is guaranteed.

DATE : is the same as timestamp. Year, month,day, hour,minute, second (down to one second).

Another possible is a sequence number. You can gauarantee that they are issued sequencially
and could be used.

Mike Krolewski

zfred wrote:

> I need best advise on porting the timestamp column to Oracle
> there might be a few possiblities -
> ROWID type ?
> DATE type with a trigger updating the column
>
> we have code that truely uses the timestamp as the row versioning to
> detect
> and handle serialised updates, without changing the code, using oracle
> must work
> equivalently..........
>
> are there any experiences out there ?
>
>
> Yacov Wolfowicz wrote:
>
>> Hi,
>> How can I port a SQL Server 6.5 database to Oracle 8.0.4?
>> I managed with the structure of the tables and all objects but still
>>
>> have a problem with the tables. Some of them are about 3M records
>> long
>> and ODBC can't deal with it.
>>
>> Thanks for any advice
>>
>> --
>> life is hard....
>> and then you die
>
Received on Sat Nov 28 1998 - 00:00:00 CST