IMPORT from file [message #13378] |
Fri, 09 July 2004 15:19 |
mitra fatolahi
Messages: 38 Registered: October 2002
|
Member |
|
|
Hello All,
I installed Oracle 10g and created database schema for a User.
In this schema, I have a table into which i need to import data from a csv file with comma delimiter. Using the same file, I was able to import the data into a table in MSSQLServer database with no problem. But I had not been able to import the same file into Oracle 10g database.
Here is the command statement I had entered in command-line window to import data into a table:
C:Documents and SettingsUser>IMP user1/user1 TABLES="secur_parms" FILE=securParms.csv IGNORE=y
Import: Release 10.1.0.2.0 - Production on Fri Jul 9 15:58:55 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
IMP-00037: Character set marker unknown
IMP-00000: Import terminated unsuccessfully
I tried using the "Import from file" wizard in Oracle 10g enterprise manager web-base application and that did not work either. I had more issue using the wizard. In fact, I noticed no where in the wizard process was i prompted to enter the table name into which i wanted to import the data. I keep getting ORA-31619 invalid dump file error. The fact that the wizard never asked me for the table name i knew that the import will fail.
I appreciate if someone can tell me what is wrong with my command statement and why i am getting the following errors:
IMP-00037: Character set marker unknown
IMP-00000: Import terminated unsuccessfully
I read "Overview of Oracle Data Pump" in Oracle 10g Database Utilities documentation:
http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10825/dp_overview.htm#i1009520
but I did not find any information to help me how to successfully import from a file into a table.
Please help!
Mitra
|
|
|
Re: IMPORT from file [message #13386 is a reply to message #13378] |
Sat, 10 July 2004 22:22 |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
IMP is meant to import data exported by EXP.
You need SQL*Loader.
Look in the documentation for the syntax you need, there are plenty examples available.
hth
|
|
|
|
|