Home » RDBMS Server » Server Utilities » Import data only
Import data only [message #73250] Tue, 09 March 2004 05:59 Go to next message
Ken Jones
Messages: 70
Registered: January 2004
Member
Hi,

I have the object structure (tables,indexes,constraints etc) set up but want to just import data. Here is my command:-

imp frb/frb@frbtest file=frbprd.frb_full_040309.dmp grants=n indexes=n rows=y log=frbprd.frb_full_040309.log constraints=n

I get create errors as the objects are already there but I do not want to create the objects but just the data to be imported:-

IMP-00015: following statement failed because the object already exists

How do I skip the object creation and just import the data please.

TIA, Ken.
Re: Import data only [message #73251 is a reply to message #73250] Tue, 09 March 2004 06:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use ignore=y
if u dont truncate the tables before loading, data will be appended and if there are any constraints ont he table, it may be violated.
imp frb/frb@frbtest file=frbprd.frb_full_040309.dmp grants=n indexes=n rows=y log=frbprd.frb_full_040309.log constraints=n ignore=y
Re: Import data only [message #73253 is a reply to message #73251] Tue, 09 March 2004 06:36 Go to previous messageGo to next message
Ken Jones
Messages: 70
Registered: January 2004
Member
Thank you!!
Re: Import data only [message #73936 is a reply to message #73251] Thu, 05 August 2004 02:48 Go to previous message
M.S. KHALED
Messages: 1
Registered: August 2004
Junior Member
Dear Sir,
I want to import only data from a dump file
to a single table of my database .

what would the simple import command be..

Thaking u
M.S.Khaled
Previous Topic: select second 25 records from a table
Next Topic: Querry.
Goto Forum:
  


Current Time: Wed Dec 25 07:28:07 CST 2024