Answer Posted / ramesh

And the Advantage are
1.Maintaincace :-Can Take Partioned tables's tablespace
offline for recovery
while other partitions are still avialable to users
Hence the Avialability

2.Performace :As the Objects are plcaed in Diffrent
Tablespaces of Diffrent Servers/locations

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1986

---

What is the difference between clustered and non-clustered index? : sql server DBA

1027

---

who owns the operating system files created by the utl_file package?

1013

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

935

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1056

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1015

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2450

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1024

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

949

---

How do you open a cluster administrator? : sql server DBA

1034

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1916

---

What are the commands used in dcl? : sql server DBA

997

---

what is a user-defined lock?

986

---

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2035

---

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

4290

---