Re: Sybase to Oracle Date

From: Chris Weiss <weisschr_at_pilot.msu.edu>
Date: Tue, 27 Jul 1999 12:57:02 -0400
Message-ID: <7nkodn$3hk$1@msunews.cl.msu.edu>

The easiest way to guarantee compatibility is to export your Sybase data in ascii file, converting dates to strings in a base format Oracle can use, eg. DD-MMM-YY. SQL-Loader for Oracle is a very powerful and simple tool for importing data, and it can easily bring in this string as a date.

You will not be able to simply import your raw data from Sybase. You will need a migration tool, or you will need to export and import ascii flat files. Oracle technet has tools to help you with migration.

Christopher Weiss
Professional Services
Compuware Corporation

geraldine grubb <ggrubb_at_indiana.edu> wrote in message news:379DDB99.1508F013_at_indiana.edu...
> Hi,
>
> How can I convert a Sybase Date to Oracle. In other words, are the
> date datatypes not compatable and what do I to fix this?
>
> Please reply to my email also.
>
> gg
> ggrubb_at_indiana.edu
>
Received on Tue Jul 27 1999 - 11:57:02 CDT