Answer / Shweta Dixit

To invoke the Data Pump Export Utility in Oracle, you can use SQL*Plus or Command Line Interface. Here's a simple example for command line interface:nn`expdp [username/password@connect_identifier] directory=data_pump_dir dumpfile=export_dumpfile.dmp tablespace_list=(table_spaces) table=(table_names);`

What is a oracle database?

1 Answers  

---

How to use "startup" command to start default instance?

1 Answers  

---

Are truncate and delete commands same? If so why?

1 Answers  

---

What is an oracle recycle bin?

1 Answers  

---

What is a sub query and what are the different types of subqueries?

1 Answers  

---

What is max rowid in oracle?

1 Answers  

---

How do you rate yourself in oracle and sql server ?

2 Answers   Keane India Ltd,

---

What is a trace file and how is it created in oracle?

1 Answers  

---

What is forall Statement ?

2 Answers   Thermotech,

---

State the difference between a primary key and foreign key?

1 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 Answers   Wipro,

---