v*****r
发帖数: 1119 | 1 数据库的database character一般是不应该改的（除非是需要upgrade).
这个问题很简单：
1. Make sure your target database characterset support German characters.
SQL> select * from v$NLS_PARAMETERS where parameter = 'NLS_CHARACTERSET';
2. You will need to identify the character set of the input file, then
either setting CHARACTERSET parameter in sqlloader control file to that
value; or settting NLS_LANG environment variable of you cient pc (if you don
't set CHARACTERSET parameter, sqlloader will use the the NLS_LANG setting
o |
|
w*r
发帖数: 2421 | 2 use ODBC based tool or fast export to write data into file (named pipe under
unix) and import to Oracle using build loader such as SQLLoader.
The benefit of using ODBC tool is it is simple and easy to migrate. Fast
export for Teradata is very very fast.
SQLLoader for oracle need some tuning of the table and infrastructure
parameter.
You can also use build insert (nolog no redo no undo) mode for oracle stack
tables (not index organized) .
easist way to do it is to use informatica to build a direc |
|
v*****r
发帖数: 1119 | 3 数据库的database character一般是不应该改的（除非是需要upgrade).
这个问题很简单：
1. Make sure your target database characterset support German characters.
SQL> select * from v$NLS_PARAMETERS where parameter = 'NLS_CHARACTERSET';
2. You will need to identify the character set of the input file, then
either setting CHARACTERSET parameter in sqlloader control file to that
value; or settting NLS_LANG environment variable of you cient pc (if you don
't set CHARACTERSET parameter, sqlloader will use the the NLS_LANG setting
o |
|
A***o
发帖数: 2783 | 4 呵呵。。。MSFT也算是进入暮年了。。。但还是软件公司咩。。。在金融
公司做挨踢真的是木前途，越大越糟糕。为毛？系统/技术老化。最近让我
接手的某个系统是98年写的，最初用的晒被子，后来移植到甲股文，主要结
构是Shell Script + SQLLoader + Stored Proc。。。
小童鞋们表看公司的招牌大小，有机会进的话最好了解一下都在干神马。。。 |
|
A***o
发帖数: 2783 | 5 呵呵。。。MSFT也算是进入暮年了。。。但还是软件公司咩。。。在金融
公司做挨踢真的是木前途，越大越糟糕。为毛？系统/技术老化。最近让我
接手的某个系统是98年写的，最初用的晒被子，后来移植到甲股文，主要结
构是Shell Script + SQLLoader + Stored Proc。。。
小童鞋们表看公司的招牌大小，有机会进的话最好了解一下都在干神马。。。 |
|
o******5
发帖数: 29 | 6 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. |
|
w*m
发帖数: 1806 | 7 LOAD DATA
INFILE 'input_File.csv’
INTO TABLE tableName
FIELDS TERMINATED BY ","
(field1,
field2,
field3,
field4)
....
question: 可不可以在字段后面加上一个"select id from..."来自动赋值给某一字段？ |
|
l******y
发帖数: 60 | 8 大牛们，有没有可以import txt或 xls的sql命令？table 已经建好，但不用sqlloader
，也不用toad中的import功能，就是sql 命令，写入script可以直接运行的？
就像SAS 中的
data XXX
infile '.....a.txt'...
或者把文件中的内容直接输入，类似SAS中的 dataline.....，但不要一行一行地
insert
多谢啦 |
|
|
B*****g
发帖数: 34098 | 10 为啥不用sqlloader，SAS那个也不是SQL |
|
l******y
发帖数: 60 | 11 北京，sqlloader要先写contl file，然后再run, 每次load的文件不一样，还要改
control file，对组里某些人来说过于麻烦，最好能run一个script就搞定load文件，
query data，输出文件一系列操作，我也没法子啊 :-)
SQL 有类似SAS input data的操作吗？ |
|
