I am getting ready to take three 3GB Access Databases and combine them into an Oracle database and I was wondering if anyone could give me suggestions on how big my datafiles, rollback segments and log files should be? Also, what is the best method to get the data from Access into Oracle? I could use VB & SQL but they would take a while.
Try a migration tool at [url]http://www.ispirer.com/chyfo.html[/url]
It provides you the fastest, the easiest and the most powerful way to migrate your database into Oracle.
It allows you to extract any data from any database. It works in conjunction with Oracle SQL Loader.
The tool creates CSV text files (moving of LOBs are fully supported), generates CREATE TABLE, CREATE INDEX scripts for Oracle and control files for SQL Loader.
The tool has a lot of other features.