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: all tables skipped in import

Re: all tables skipped in import

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 24 Mar 2004 17:47:16 +0100
Message-ID: <c3se2k$ca2$1@news.BelWue.DE>


Kevin Murphy wrote:
> Pardon my newbie-ness. Know also that I am using 9.2.0.1.0
> Developer's Release for Mac OS X.
>
> I am trying to import an export from another database, and no matter
> what I do, all the tables are skipped, but there are no errors
> produced by imp, and there are also no errors in alert_SID.log and
> SID_ora_*.trc. You can see one of my many failed imp commands and
> output below, followed by some of the meta-data created via the
> indexes=n/indexfile=xxx options. The 'egenome' user, which exists in
> both databases, has the DBA role and a default tablespace with
> unlimited quota on it. (I created a table and looked to make sure it
> was in the right tablespace). As you can see from the meta-data, the
> tables are owned by 'egenome' in the original database, and they
> happened to be in the USERS_TABLE tablespace. I tried creating a
> tablespace with the same name in the new database and making that the
> default tablespace for 'egenome' there, but it made no difference.
> As an alternative to 'full=y', I also tried
> 'fromuser=egenome/touser=egenome'.
>
> Any insights?
>
> Thanks,
> Kevin Murphy
>
> $ imp egenome/egenome full=y indexes=n
> indexfile=create_indexes_20040324.sql file=/tmp/Oracle.dmp
> log=import_20040324.log commit=y
>

Kevin,

omit the indexfile= param and you should be fine.

HTH Holger Received on Wed Mar 24 2004 - 10:47:16 CST

Original text of this message

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