tools for importing data into oracle - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

tools for importing data into oracle

tools for importing data into oracle# Database - 数据库

G*G2009-02-25 08:02

1 楼

looking for tools for importing data to oracle.
easy to use
no requirement for creating table before importing(it can automatically
create the table including its field and field width, just as MS ACCESS does)

B*g2009-02-25 08:02

2 楼

sql server 2008 exp or above

does)

【在 G***G 的大作中提到】

: looking for tools for importing data to oracle.
: easy to use
: no requirement for creating table before importing(it can automatically
: create the table including its field and field width, just as MS ACCESS does)

o*52009-02-25 08:02

3 楼

Bethic Software's impexp32 is the best tool I used for importing data to
Oracle. However it need to have the target table already exists.
The other easy solution is Access. You first dump data to Access and save it
to Oracle via an ODBC connection. It will create the table.
Oracle's own SQL loader or external table are also useful. However it
requires some coding.

B*g2009-02-25 08:02

4 楼

请介绍一下这个，比sql developer强在哪？

it

【在 o******5 的大作中提到】

: Bethic Software's impexp32 is the best tool I used for importing data to
: Oracle. However it need to have the target table already exists.
: The other easy solution is Access. You first dump data to Access and save it
: to Oracle via an ODBC connection. It will create the table.
: Oracle's own SQL loader or external table are also useful. However it
: requires some coding.

o*52009-02-25 08:02

5 楼

I never use sql developer to import data to Oracle. So do not know whether
it will be better than impexp32 or not. Using impexp32, it will ask for the
source file and target table and how to map fields. It will give your
options on how to load the data, either append data or delete/insert. I used
to use sqlloader and it is a pain to create the control file and determine
how to handle hard return in the field.
BTW, impexp32 is part of Golden32 which is a good SQL tool.

G*G2009-02-25 08:02

6 楼

is there any good tools for us to create the target table according to a
being imported text file, especially for the field type and field width?
importing is easy, but creating such a table with proper field type and
filed width is not easy, especially for a big text file such as 1000 columns
and 100,000,000 rows.

the
used
determine

【在 o******5 的大作中提到】

: I never use sql developer to import data to Oracle. So do not know whether
: it will be better than impexp32 or not. Using impexp32, it will ask for the
: source file and target table and how to map fields. It will give your
: options on how to load the data, either append data or delete/insert. I used
: to use sqlloader and it is a pain to create the control file and determine
: how to handle hard return in the field.
: BTW, impexp32 is part of Golden32 which is a good SQL tool.

B*g2009-02-25 08:02

7 楼

1. for such a big data, you should create tables yourself.
2. text file most time are Fixed Length or Delimited. Fixed Length, you know
the length of each filed. For delimited file fields length and type of
fields(both Fixed Length and Delimited), I think all (at least most)
software will decide based on data in the first data line(ignore header).
3. if the coming data is complete unknown, import to staging table first,
then....
4. Your company does not have BA?

columns

【在 G***G 的大作中提到】

: is there any good tools for us to create the target table according to a
: being imported text file, especially for the field type and field width?
: importing is easy, but creating such a table with proper field type and
: filed width is not easy, especially for a big text file such as 1000 columns
: and 100,000,000 rows.
:
: the
: used
: determine

G*G2009-02-25 08:02

8 楼

what is ba?

know

【在 B*****g 的大作中提到】

: 1. for such a big data, you should create tables yourself.
: 2. text file most time are Fixed Length or Delimited. Fixed Length, you know
: the length of each filed. For delimited file fields length and type of
: fields(both Fixed Length and Delimited), I think all (at least most)
: software will decide based on data in the first data line(ignore header).
: 3. if the coming data is complete unknown, import to staging table first,
: then....
: 4. Your company does not have BA?
:
: columns