1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

using comand prompt how can import table data and table
space with example

Question Posted / kavithanedigunta

Answers were Sorted based on User's Feedback



using comand prompt how can import table data and table space with example..

Answer / raja

If u want to import only table data then you can opt for
sql loader and if u want to import the table sapce then you
can go for imp command

Is This Answer Correct ?    5 Yes 2 No

using comand prompt how can import table data and table space with example..

Answer / pradeep

imp command can be used for both table data and table space
import. Add one parameter for table data import (tables=
TABLE_NAME1,TABLE_NAME2).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is a subquery in sql?

0 Answers  

Why do we use joins?

0 Answers  

What is the fastest way of accessing a row in a table?

5 Answers   TCS,

How can I create a table from another table without copying any values from the old table?

8 Answers  

how to write date and time literals? : Sql dba

0 Answers  




What are code pages ?

1 Answers   BirlaSoft,

What is the use of index in hive?

0 Answers  

What operating systems are supported by oracle sql developer?

0 Answers  

Why primary key is required?

0 Answers  

How to come back in normal stage in Mutating Table if mutating table is locked or update data?

2 Answers  

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,

Can we insert in view in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories