Oracle DBA Interview Question
Question: User called and said he or she dropped all tables in schema and want to restore it. How will you restore all tables?
Please post your answer in comments.
Posts tagged ‘answer’
Nov 17
- 19c New Feature
- 18c new feature
- 12.2 New Feature
- Database Replay
- Index Monitoring in Oracle 12.2
- Real Application Testing: Database Replay New Features
- APEX on a 12.2 DB Configuring an Email Server with SSL/TLS gets ORA-24263: Certificate Of The Remote Server Does Not Match The Target
- 12c Release 2 New Feature : Statistics Advisor
- Optimizer Statistics Advisor In 12.2
- Compiling Java Stored Procedures Using Native Compilation Takes Longer Time in 12.2 Compared to Lower Releases
- How to Create AWR for PDB level on 12.2 Step by Steps
- Column Collation and Case Insensitive Database
- Rename database and then move datafile online
- Oracle Database 12c Release 1 (12.2) Upgrade New Features
- Data Pump: Oracle Database 12c Release 2 (12.2) New Features
- DBUA : Understanding New Changes / Features
- Database In-Memory (IM) Column Store Join Groups
- How to Control and Monitor the Memory Usage (Both SGA and PGA) Among the PDBs in Mutitenant Database
- Database In-Memory (IM) Column Store Expressions
- JOB_QUEUE_PROCESSES=4000 CAN ONLY HANDLE A MAXIMUM OF 1024 JOBS
- How To Create In Memory Jobs
- Database In-Memory (IM) FastStart
- Restricting the PGA Usage Per Session Level Using Resource Manager
- EM Express: Single Port Access for Multitenant
- Managing OS Resources Among PDBs Using PDB Perfromance Profiles
- RECOVER DATABASE UNTIL AVAILABLE REDO
- I/O Rate Limits for PDBs
- 12.2 Upgrade
- Error
- Demo / Workshop / example
WikiDBA 