New answers tagged dba
How did you stage your duplicate area? Are you duplicating to the same host? All involved files must be accessible by both target and auxiliary instances. Please check out the docs and see if there is any step missing: http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmdupdb.htm#BRADV010 Also verify wether you can "ls -l ...
Move the #sql files. Usually you will find those files in the tmp directory. It is recommended to use pt-online-schema rather than direct alter to avoid locking. mysql> show variables like '%tmp%';
Go into the filesystem (DOS prompt, shell prompt, whatever) and delete (rm, whatever) any files starting with #sql Also check to see how much free space exists on disk. ALTER usually copies the entire table over.
I would suggest using sp_WhoIsActive - provided you have access to DMV data. Alternatively, you can use diagnostic queries from Glen Berry or sp_AskBrent. A good start would be A Performance Troubleshooting Methodology for SQL Server
Though logging into the machine and analyzing the wait chain on the Resource Monitor could give some extra info (for instance if sqlservr.exe thread is blocked waiting for lsass.exe it could mean it is blocked at a authentication validation), what you'd really want is to be granted the VIEW SERVER STATE permission so you can view the DMVs that might help ...
Lets define the controlfile in oracle: it is a small binary file that records the physical structure of the database and its include: 1) The database name. 2) Names and locations of associated datafiles and redo log files. 3) The timestamp of the database creation 4) The current log sequence number 5) Checkpoint information
Just in case somebody else needs, I am posting the solution I used. Instead of using fromuser and touser options, I used remap_schema option: > impdp user1/password DIRECTORY=backup_dir DUMPFILE=Dump.dmp FULL=Y > remap_schema=user2:user1
Top 50 recent answers are included