Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: EXPORT IMPORT SIMPLE QUESTION
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