Creating Database from 3GB Access Databases
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Creating Database from 3GB Access Databases

  1. #1
    Join Date
    Sep 2000
    Posts
    2
    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.

    Thanks for any assistance.

  2. #2
    Join Date
    Aug 2000
    Location
    Toronto, Ontario Canada
    Posts
    52
    There are several options to migrating data from Access to Oracle. You could spool the data out to a flat file, but at 3 gigs, thats quite a large spool file.

    I've used the Oracle Migration Workbench tool for Access and it works quite nicely. It does everything with respect for migration including layout. You can get it at technet.oracle.com

    As for the layout, this would depend on individual tables, disks etc. There are several notes on metalink regarding your issue, but tuing is an onging issue.

  3. #3
    Join Date
    Jan 2001
    Posts
    18
    Hi,

    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.

    Best regards, Dmitry.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width