Re: importing only data from existing tables

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 13 Nov 2000 19:12:28 +0100
Message-ID: <974141923.19221.0.pluto.d4ee154e@news.demon.nl>

<mednyk_at_my-deja.com> wrote in message news:8up8ls$5di$1_at_nnrp1.deja.com...
> In article <8up6dc$3ac$1_at_nnrp1.deja.com>,
> David Fitzjarrell <oratune_at_aol.com> wrote:
> > In our last gripping episode mednyk_at_my-deja.com wrote:
> > > Hi!
> > > Having a problems again. How it is posible to import data from .dmp
> > > file , which contain tables with data to clean database.
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> >
> > What problems are you experiencing?
> >
> > --
> > David Fitzjarrell
> > Oracle Certified DBA
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >

>

> i have created tables( structure only) without data. I have a dump file
> created from export. How can I transfer data into the Newly created
> database?

>
>

> Sent via Deja.com http://www.deja.com/
> Before you buy.

Just run imp and make sure ignore=y on the commandline or you answer y to ignore errors in dialogue mode.
If you type imp and hit return you will be in dialogue mode. Otherwise you need something like
imp <username/password>(@servicename) file=<your filename> full=y buffer=8192000 commit=y ignore=y log=<any filename>

Obviously, this is a -sorry to say so- RTFM question. Please read the Oracle Server Utilities Guide for answers to your further queries, or you will become a real bore to this group and usually be ignored. If you don't have the doc they are online at http://technet.oracle.com

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Nov 13 2000 - 12:12:28 CST