1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????
2 6573I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?
1 3874Post New DB Administration Questions
What are the different ways you can create databases in sql server? : sql server DBA
Where would you look for errors from the database engine?
What is transparent data encryption? : sql server DBA
How do you open a cluster administrator? : sql server DBA
Query processing is slow(eg select query)how will u solve that
How would you extract DDL of a table without using a GUI tool?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What is fill factor? : sql server DBA
what is grd?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
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