| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Moving from Access to oracle 8.0
--------------BD0FDFFF5D4EC875D0C07757 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
Oracle has a utility for migrating Access databases to Oracle. Check out technet.oracle.com.
Dave Turner
Rajagopal Venkataramany wrote:
> Radhika,
>
> Dump the contents from Access into a comma seperated format or a
> positional format (fixed record length) and use sql loader to
> take the details into Oracle.
>
> Regards
> Rajagopal Venkataramany
>
> ----Original Message Follows----
> Reply-To: ORACLE-L_at_fatcity.com
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Date: Mon, 15 May 2000 20:37:02 -0800
>
> Radhika,
> I do not know ur requirements and integrity constraints. One Suggestion. Do
> not use ODBC connection. You will run into probs in table names, field
> names.
>
> Maheshwara Rao, L., Teki
> E Mail : teki01_at_mediaone.net
>
> -----Original Message-----
> Putumbaka
> Sent: Monday, May 15, 2000 11:06 PM
> To: Multiple recipients of list ORACLE-L
>
> All,
> currently we have a Access database with 25 to 30 tables. Client is
> planning to no longer use Access and to migrate the whole database to
> Oracle. What is the best way to move from Access to oracle 8.0. Any
> suggestions are appreciated.
> Thanks.
> Radhika.
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Radhika Rao Putumbaka
> INET: radhikaraop_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Author: Maheshwara Rao, L., Teki
> INET: teki01_at_mediaone.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Rajagopal Venkataramany
> INET: rajagopalvr_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Dave Turner, Senior Database Administrator, Linuxcare, Inc. 913.383.3052 tel, 913.579.3803 cel, 877.443.9553 pager dturner@linuxcare.com, http://www.linuxcare.com/ Linuxcare. Support for the revolution. -- --------------BD0FDFFF5D4EC875D0C07757 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> Oracle has a utility for migrating Access databases to Oracle. Check out technet.oracle.com. <p> Dave Turner <p>Rajagopal Venkataramany wrote: <blockquote TYPE=CITE>Radhika, <p> Dump the contents from Access into a comma seperated format or a <br> positional format (fixed record length) and use sql loader to <br> take the details into Oracle. <p>Regards <br>Rajagopal Venkataramany <p>----Original Message Follows---- <br>Reply-To: ORACLE-L_at_fatcity.com <br>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> <br>Date: Mon, 15 May 2000 20:37:02 -0800 <p>Radhika, <br>I do not know ur requirements and integrity constraints. One Suggestion. Do <br>not use ODBC connection. You will run into probs in table names, field <br>names. <p>Maheshwara Rao, L., Teki <br>E Mail : teki01_at_mediaone.net <p>-----Original Message----- <br>Putumbaka <br>Sent: Monday, May 15, 2000 11:06 PM <br>To: Multiple recipients of list ORACLE-L <p>All, <br> currently we have a Access database with 25 to 30 tables. Client is <br>planning to no longer use Access and to migrate the whole database to <br>Oracle. What is the best way to move from Access to oracle 8.0. Any <br>suggestions are appreciated. <br>Thanks. <br>Radhika. <br>________________________________________________________________________ <br>Get Your Private, Free E-mail from MSN Hotmail at <a href="http://www.hotmail.com">http://www.hotmail.com</a> <p>-- <br>Author: Radhika Rao Putumbaka <br> INET: radhikaraop_at_hotmail.com <p>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 <br>San Diego, California -- Public Internet access / Mailing Lists <br>-------------------------------------------------------------------- <br>To REMOVE yourself from this mailing list, send an E-Mail message <br>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in <br>the message BODY, include a line containing: UNSUB ORACLE-L <br>(or the name of mailing list you want to be removed from). You may <br>also send the HELP command for other information (like subscribing). <p>-- <br>Author: Maheshwara Rao, L., Teki <br> INET: teki01_at_mediaone.net <p>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 <br>San Diego, California -- Public Internet access / Mailing Lists <br>-------------------------------------------------------------------- <br>To REMOVE yourself from this mailing list, send an E-Mail message <br>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in <br>the message BODY, include a line containing: UNSUB ORACLE-L <br>(or the name of mailing list you want to be removed from). You may <br>also send the HELP command for other information (like subscribing). <p>________________________________________________________________________ <br>Get Your Private, Free E-mail from MSN Hotmail at <a href="http://www.hotmail.com">http://www.hotmail.com</a> <p>-- <br>Author: Rajagopal Venkataramany <br> INET: rajagopalvr_at_hotmail.com <p>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 <br>San Diego, California -- Public Internet access / Mailing Lists <br>-------------------------------------------------------------------- <br>To REMOVE yourself from this mailing list, send an E-Mail message <br>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in <br>the message BODY, include a line containing: UNSUB ORACLE-L <br>(or the name of mailing list you want to be removed from). You may <br>also send the HELP command for other information (like subscribing).</blockquote> <pre>-- Dave Turner, Senior Database Administrator, Linuxcare, Inc. 913.383.3052 tel, 913.579.3803 cel, 877.443.9553 pager dturner@linuxcare.com, <A HREF="http://www.linuxcare.com/">http://www.linuxcare.com/</A>Received on Tue May 16 2000 - 14:24:35 CDT
 |
 |