Home » RDBMS Server » Server Utilities » IMPORT from file
IMPORT from file [message #13378] Fri, 09 July 2004 15:19 Go to next message
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 Go to previous messageGo to next message
Frank
Messages: 7880
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
Re: IMPORT from file [message #349348 is a reply to message #13378] Sat, 20 September 2008 09:31 Go to previous messageGo to next message
mrvafaei
Messages: 27
Registered: September 2008
Junior Member

Hi ,

you can use Oracle external table for loading CSV , TXT file into oracle , it's dynamic and very usefull ,
or
if you want to use some other type of files like excel , you can use Oracle HS feature , you can directly select data from excel file with oracle HS feature .

best regards,
Reza .
Re: IMPORT from file [message #349351 is a reply to message #349348] Sat, 20 September 2008 12:19 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
This post is over 4 years old! I surely hope the OP solved his problem by now.
Previous Topic: Control file to search and skip rows
Next Topic: Importing Oracle 10 dump exported via Oracle 9.0 export utility
Goto Forum:
  


Current Time: Tue Dec 06 10:33:36 CST 2016

Total time taken to generate the page: 0.12029 seconds