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

Last Comment

slightwv (䄆 Netminder)

8/22/2022 - Mon

Qlemo

6/2/2021

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

6/2/2021

ASKER

i know the schema in this database and the schema exist

slightwv (䄆 Netminder)

6/2/2021

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