Answer Posted / ravindra

Hi,

Correct if i am wrong.We can do through package
procedure.Create empty database on target database and
create dblink between two databases.Now we have to prepare
package and transfer the each schema.
Thanks & Regards,
Ravindra

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1500

---

what is the use of recording information about current session?

566

---

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?

1996

---

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

608

---

What purpose does the model database server? : sql server DBA

624

---

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2226

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

1688

---

what are the benefits of flashback feature?

589

---

how can you find out if a table can be redefined?

593

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

601

---

What is dbcc? : sql server DBA

777

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

1723

---

Why would you call update statistics? : sql server DBA

576

---

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

558

---

how does an oracle clusterware manage crs resources?

569

---