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 do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What the different topologies in which replication can be configured? : sql server DBA
Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog
who owns the operating system files created by the utl_file package?
Explain the difference between a data block, an extent and a segment.
what is a crs resource?
what is incremental checkpoint?
What are the different ways of moving data or databases between servers and databases in SQL Server?
now one user in online.now i want drop him..how do u drop him?
What view would you use to look at the size of a data file?
how to restore files with rman?
What are the steps you will take, if you are tasked with securing an SQL Server?
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)