Avatar of chalie001
chalie001
 asked on

tables not exported when doing import

hi am importing data in 19c  am not able to import my tables but i have tables in my schema
expdp schemaname/maint4ncs@ncs_alpha schemas=schemaname directory=TEST_DIR dumpfile=nlatestexpd.dmp logfile=expdpnatnew.log

Export: Release 19.0.0.0.0 - Production on Tue Jun 1 10:47:37 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "schemaname"."SYS_EXPORT_SCHEMA_01":  schemaname/********@ncs_alpha schemas=schemaname directory=TEST_DIR dumpfile=nlatestexpd.dmp logfile=expdpnatnew.log
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Master table "schemaname"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for schemaname.SYS_EXPORT_SCHEMA_01 is:
  /u01/app/oracle/oradata/nlatestexpd.dmp
Job "schemaname"."SYS_EXPORT_SCHEMA_01" successfully completed at Tue Jun 1 10:48:20 2021 elapsed 0 00:00:42


Oracle Database

Avatar of undefined
Last Comment
slightwv (䄆 Netminder)

8/22/2022 - Mon
Qlemo

As instructed in your previous question, you checked the sql file generated for the correct schema? The output hints towards a valid but empty schema name.
chalie001

ASKER
i know the schema in this database and the schema exist
slightwv (䄆 Netminder)

You should see the list of tables exported.  Since what you posted dosn't have anything, your schema provided in the expdp command likely doesn't exist in the database.

I create a new schema in my database called BOB.  I created a table with one row.

Then I ran expdp schemas=bob ...the rest of the parameters, I got:
Starting "SYS"."SYS_EXPORT_SCHEMA_01":  /******** AS SYSDBA directory=data_pump_dir schemas=bob
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . exported "BOB"."TAB1"                                5.054 KB       1 rows
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
  C:\ORACLE\ADMIN\ORCL\DPDUMP\EXPDAT.DMP
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at Wed Jun 2 12:46:48 2021 elapsed 0 00:00:35

Open in new window


Notice the table with number of rows being reported?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
chalie001

ASKER
i have 700 tables in this schema 
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.