Michael - This was discussed in detail recently on this list. Basically,
what I recall is:
- The key is to define the tables in Oracle first, then import your
Access data. You don't want to let Access define the tables, and I think you
are learning this.
- How large are the Memo fields? Can you store them in a varchar2
column? Can you break them into multiple varchar2 columns, like maybe they
have some internal structure? If the latter, you could create a child table
to store each. Just a wild thought.
- If you are just doing a few tables, and your posting uses the word
"small", then this should work fine. If you had many tables, someone
mentioned an Oracle migration tool provided by Oracle that worked well.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Monday, January 14, 2002 9:46 AM
To: Multiple recipients of list ORACLE-L
Hi List,
I have a small Access database which needs to be migrated to Oracle. I can
use ODBC to convert the data from Access to Oracle. However I encountered
the following constraints.
1. Access's MEMO datatype will be converted to Oracle's LONG. Oracle allows
only one column with LONG in each table. How about if I have multiple
columns with MEMO in the Access database?
2. ODBC does not allow me to pre-create the table in Oracle and then export
the data. Otherwise it will complain that the table already exists.
Does anybody on the list know if there is any better way or utilities to
convert from Access to Oracle?
Thanks,
Michael
**********************************************************************
This e-mail contains privileged attorney-client communications and/or
confidential information, and is only for the use by the intended recipient.
Receipt by an unintended recipient does not constitute a waiver of any
applicable privilege."
Reading, disclosure, discussion, dissemination, distribution or copying of
this information by anyone other than the intended recipient or his or her
employees or agents is strictly prohibited. If you have received this
communication in error, please immediately notify us and delete the original
material from your computer."
Sempra Energy Trading Corp. (SET) is not the same company as SDG&E or
SoCalGas, the utilities owned by SET's parent company. SET is not regulated
by the California Public Utilities Commission and you do not have to buy
SET's products and services to continue to receive quality regulated service
from the utilities."
**********************************************************************
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Wu
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
