How will u copy the objects of one schema to another schema in datapump & export/import?
- 1 Answers
- 4496 Views
- I also Faced
- E-Mail Answers
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 |
how can you connect from 10g user to 11g user??
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
You have just compiled a PL/SQL package but got errors, how would you view the errors?
why we use cursors
what is incremental checkpoint?
What is RAID and what are different types of RAID configurations?
A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?
Give two examples of how you might determine the structure of the table DEPT.
What is dbcc? : sql server DBA
When a user process fails, what background process cleans up after it?
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
How many packages we have in db
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
