Database Administration (MOSC)

MOSC Banner

IMPDP is completed successfully but no rows imported on table

edited May 6, 2021 5:50PM in Database Administration (MOSC) 4 comments

IMPDP is completed successfully and i can see in IMPDP log that the rows of the table imported.

But, when i am issuing the view ALL_TABLES to check the num_rows, its showing empty rows..

select table_name,num_rows from all_tables where table_name in ('TBALE1');

TABLE_NAME       NUM_ROWS

-------------------- ----------

PS_Q_BALANCE_ID

PS_Q_ADDL_PAY_DATA

PS_Q_DEPEND_BENEF

PS_Q_DISCIP_STEP

PS_Q_DISCIPLN_STEP

PS_Q_DISCPLN_ACTN

PS_Q_EARNINGS_SPCL

PS_Q_EEO_JOB_GRP

PS_Q_EMPLOYEES

PS_Q_EMPLOYMENT

PS_Q_GC_ACQ_EE_DT

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center