Oracle Database Discussions

Hello everyone.

I've got a project going on and would like to get some feedback.

My project is to migrate a database for a call-support system over to Oracle 10g R2.

The database has no constraints, no foreign keys, etc.

Everything is handled by the call-support system.

However, when the original database was created (2002), the designer created 2 to 3 columns per table as LONG objects.

The database is now 1.33gb and contains 1.7 million entries in 172 different tables.

I have a backup file from the program, which allows me to use the program to import the database structure and data into a new database. However, the LONG objects are preventing me from doing this in Oracle.

An idea I have come up with is to import the database structure and data into an Access database, and then migrate that Access database over to the Oracle database one table at a time, converting all the LONG objects to CLOBs.

Is there an easier way to do this?

Is this way even possible?

Thanks,

Joseph