Mohammed said:
I have Oracle database about 50 GB can I Import into access database. Is
it
possible. It will work good. This access database can support 50 GB data
smoothly. Anyone can help me in this?
You find that ms-access is a LOT faster then oracle on a single desktop
machine. However, access is limited to 2 gig file sizes. So, if each table
is less then 2 gig in size, you can place each table in a separate mdb file,
and the only limitation in this case is the size of the hard drive.
Keep in mind separating tables into separate mdb files means that you can't
enforce relationships between each table. (you can most certainly design and
build queries that relate the tables...you just can't enforce the relations
ships at the engine level).
However, as mentioned, you find the performance much faster in ms-access for
most operations. (this is because there is no large data base engine,
transactions, atomic updates, and a network socket connection between you
and the data on the hard drive. ms-access very much just scrapes data right
off the hard drive where server database engines have "many" layers of
software between you and the data).
However, given the size of the data sets you have, if any of the tables are
beyond 2 gig in size, then ms-access is likey not the best choice here.
