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: EXPORT IMPORT SIMPLE QUESTION

Re: EXPORT IMPORT SIMPLE QUESTION

From: David Fitzjarrell <oratune_at_aol.com>
Date: Fri, 22 Dec 2000 21:55:15 GMT
Message-ID: <920ik1$u91$1@nnrp1.deja.com>

In our last gripping episode "kush" <kdhakal_at_eline.com> wrote:
> Thanks for answering my question, as you said I did
> imp x/y file=expdat1.dmp indexfile=expdat1.sql fromuser=<username>
> and the output was:
> Export file created by EXPORT:V08.01.05 via conventional path
> import done in US7ASCII character set and US7ASCII NCHAR character set
> . . skipping table "x"
>
> . . skipping table "Y"
>
> . . skipping table "Z"
> so it went like this for almost half of the table names that I
 exported, but
> almost half of the tables including employee table is missing here
 and also
> missing from expdat1.sql
> what could be the reason?
> thanks in advance. I am running Oracle 8.1.5 on Solaris.
>
> kush
> "David Fitzjarrell" <oratune_at_aol.com> wrote in message
> news:920cd2$p7c$1_at_nnrp1.deja.com...
> > In our last gripping episode "kush" <kdhakal_at_eline.com> wrote:
> > > hello! please bear with me, this might be simple question.
> > > I am trying to do export in user mode and import from the file
 only
 specific
> > > tables(by table mode). For that I did following
> > > exp x/y file=expdat1.dmp (of course x and y has meaning)
> > > export ran successfully without any warning. And I can see the
> > > table(employee) exported which I want to import later on.
> > > Now, I drop the table(employee) which I want to import from this
 export file
> > > and try to do import in table mode by
> > > imp x/y file= expdat1.dmp tables= employee
> > > it gives me following error
> > > Export file created by EXPORT:V08.01.05 via conventional path
> > > import done in US7ASCII character set and US7ASCII NCHAR
 character set
> > > . importing SA's objects into SA
> > > IMP-00033: Warning: Table "EMPLOYEE" not found in export file
> > > Import terminated successfully with warnings.
> > >
> > > Any ideas? My question is can we import in table mode from the
 exported file
> > > which was created in user mode export? if the answer is Yes, why
 I am
> > > getting this error.
> > > thanks in advance.
> > >
> > > kush
> > >
> > >
> >
> > Yes, you can export in user mode and import in table mode. Check
 the
> > export file for the table in question by running imp and specifying
 the
> > indexfile parameter:
> >
> > imp x/y file=expdat1.dmp indexfile=expdat1.sql
> >
> > This will place all of the CREATE statements (tables, indexes) in
 the
> > file named expdat1.sql. You may then check this file for EMPLOYEE
 and
> > see if the table actually exists. My first thought is you have
> > misspelled the name -- possibly the table is named EMPLOYEES? There
> > may also be hidden control characters in the table name that will
 cause
> > it to display as EMPLOYEE but will prevent that spelling from being
> > matched. This is a long shot, so to speak, but it could be a (very
> > remote) possibility.
> >
> > --
> > David Fitzjarrell
> > Oracle Certified DBA
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>

If the table is missing from expdat1.dmp it will be missing from expdat1.sql. I am at a loss as to why almost half of the tables are missing. Since you have already dropped the table you wished to export you will need to recreate it from scratch.

I always check the export file with the import command stated in the previous post to ensure that the file is intact before I drop any database object. I also log the export and import activity with the log parameter:

exp x/y file=... ... ... log=...

This creates a log file of the screen output so I may check it later for errors I may have missed.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/
Received on Fri Dec 22 2000 - 15:55:15 CST

Original text of this message

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