How will u copy the objects of one schema to another schema in datapump & export/import?
Answer / kittu_chintu2005
Impdp directory=dpump_dir1 dumpfile=xxxxx.dmp remap_schema=user1:user2
Imp file=xxxxxx.dmp \ from user=user1 touser=user2
| Is This Answer Correct ? | 4 Yes | 2 No |
what is difference between user managed backup and rman backup?
orra 1555 what is this error,why it is occur?
Give the stages of instance startup to a usable state where normal users may access it.
What is blocking and how would you troubleshoot it?
How many packages we have in db
hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?
Give the two types of tables involved in producing a star schema and the type of data theyhold.
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How do you trace the traffic hitting a sql server? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the recovery models for a database? : sql server DBA
when does an alert gets signaled?
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)