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 6568I 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 3873Post New DB Administration Questions
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
what do you understand by fine-grained auditing?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
how can you communicate with operating system files from oracle?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the different sql server versions you have worked on? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Query processing is slow(eg select query)how will u solve that
how does an oracle clusterware manage crs resources?
You create a private database link and upon
connection, fails with: ORA-2085: connects to