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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: import not picking up table from dmp file

Re: import not picking up table from dmp file

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: 2005-12-17 09:20:13
Message-id: f09dd6280512170020o59c11c08u17f596fb033646ba@mail.gmail.com


Is it a materialized view by chance?
do
select owner,object_name,object_type from dba_objects where object_name='MISSING_OBJECT';

On 12/16/05, Scott Stefick wrote:
>
> Oracle Version 9.2.0.5
> OS Version: HPUX 11i
>
> We're taking a full export from one database to import into another
> 9.2.0.5 database. In the export log it shows that it exported 147K rows
> from this table. When I run an import into the other database, all of my
> tables get imported except for one.
>
Received on Sat Dec 17 2005 - 09:20:13 CST

Original text of this message

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