Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> all tables skipped in import
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
![]() |
![]() |