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

all tables skipped in import

From: Kevin Murphy <murphy_at_genome.chop.edu>
Date: 24 Mar 2004 08:16:12 -0800
Message-ID: <7782b51c.0403240816.1eef0730@posting.google.com>


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

Import: Release 9.2.0.1.0 - Developer's Release on Tue Mar 23 16:04:38 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Developer's Release
With the Partitioning and Oracle Data Mining options

Export file created by EXPORT:V09.02.00 via direct path import done in US7ASCII character set and AL16UTF16 NCHAR character set
.. . skipping table "CLONE_SNP"

.. . skipping table "HELP"

.. . skipping table "PLAN_TABLE"

.. . skipping table "SNP_CLONES"

....

.. . skipping table "TRANSCRIPT_MGC"

Import terminated successfully without warnings.

$ head -7 create_indexes_20040324.sql

REM CREATE TABLE "EGENOME"."CLONE_SNP" ("CHR" VARCHAR2(2), "CHR_SEQ1" REM NUMBER(15, 0), "CHR_SEQ2" NUMBER(15, 0), "ACC_ID" VARCHAR2(15), REM "SEQ1" NUMBER(15, 0), "SEQ2" NUMBER(15, 0), "ORIENT" VARCHAR2(2)) REM PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536
REM FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USERS_TABLE" LOGGING REM NOCOMPRESS ;
REM ... 26630 rows Received on Wed Mar 24 2004 - 10:16:12 CST

Original text of this message

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