How Can I Know My Require Table Is Available In Export Dump File?

1.	How Can I Know My Require Table Is Available In Export Dump File?
Answer» Create index file of export dump file USING IMPORT with index file command. A TEXT file will be generating with all table and index object name with NUMBER of rows. You can confirm your require table object from this text file. If you are using datapump then there is parameter CALLED "sqlfile" in impdp. Create index file of export dump file using import with index file command. A text file will be generating with all table and index object name with number of rows. You can confirm your require table object from this text file. If you are using datapump then there is parameter called "sqlfile" in impdp.

Answer»

Create index file of export dump file USING IMPORT with index file command. A TEXT file will be generating with all table and index object name with NUMBER of rows. You can confirm your require table object from this text file. If you are using datapump then there is parameter CALLED "sqlfile" in impdp.

Create index file of export dump file using import with index file command. A text file will be generating with all table and index object name with number of rows. You can confirm your require table object from this text file. If you are using datapump then there is parameter called "sqlfile" in impdp.

Discussion

No Comment Found

Related InterviewSolutions

What Is Full Backup?
Which Command I Should Need To Execute To Back Up Database Which Is Running On Noarchivelog Mode?
Have You Faced Any Recovery Scenario? Explain How You Resolved It?
Why Export/data Pump Backup Called As Logical Backup?
Why We Should Need To Open Database Using Resetlogs After Finishing Incomplete Recovery?
What Is The Complete Recovery?
How Do You Recover From The Loss Of Data File If Database Is Running In Archive Log Mode?
Archive Logs Are Being Generated Around 20gb In My Production Large Database. But One Day Almost Double Archives Were Generated. What Is The Reason Behind This? How Can I Check It?
How Can I Know My Require Table Is Available In Export Dump File?
What Is The Meaning Of Lgwr Sync And Lgwr Async In Log Archive Destination Parameter Of Standby Configuration?