You create a private database link <link name> and upon
connection, fails with: ORA-2085: <Link name> connects to
<fully qualified remote db name>. What is the problem? How
would you go about resolving this error?
No Answer is Posted For this Question
Be the First to Post Answer
deleted of control file how will u recover control file?
An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
how can you connect from 10g user to 11g user??
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?
how can you record information about current session?