Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: import not picking up table from dmp file
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
![]() |
![]() |