Datapump backup steps?
Answer / kittu_chintu2005
Create a file structure @ oracle level by issuing the statement "create directory dpump_dir1 as '/disk01/oradata/mine/dpump'';" "grant read, write to user1, user2;"
@ OS "level mkdir -p /disk01/oradata/mine/dpump"
And then issue the statement @ OS level "expdp directory=dpump_dir1 dumpfile=xxxxx.dmp"
| Is This Answer Correct ? | 3 Yes | 0 No |
what is a user-defined lock?
How would you determine the time zone under which a database was operating?
What happens on checkpoint? : sql server DBA
Name a tablespace automatically created when you create a database.
1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????
hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table
what are the differences of where and if in SAS?
How would you extract DDL of a table without using a GUI tool?
How many memory layers are in the shared pool?
Explain what partitioning is and what its benefit is.
what is ora 600?
What questions might be they ask in managerial round in capgemini.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)