Re: importing only data from existing tables

In article <974141923.19221.0.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
>
> <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.

It is my first week as DBA. Even first week in this environment, so i realy need a help even in such a stupid for you stuff.
> > > >
> > >
> > > 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 13 2000 - 14:46:02 CST