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 6717I 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 3943Post New DB Administration Questions
internal architecture
What the different types of replication and why are they used? : sql server DBA
how does an oracle clusterware manage crs resources?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Query processing is slow(eg select query)how will u solve that
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
what are the types of connection load-balancing?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you process messages in order asynchronously?
how to restore files with rman?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?