Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: importing only data from existing tables

Re: importing only data from existing tables

From: <memphisrs_at_my-deja.com>
Date: Mon, 13 Nov 2000 20:55:52 GMT
Message-ID: <8upkgk$gef$1@nnrp1.deja.com>

If you can't read the Oracle documentation CD, then you are in real trouble!

In article <8upju7$fse$1_at_nnrp1.deja.com>,   mednyk_at_my-deja.com wrote:
> 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.

>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US