using comand prompt how can import table data and table
space with example
Answers were Sorted based on User's Feedback
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 |
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 |
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?
Do you understand the meaning of exception handling?
What is union, minus and interact commands?
wht is the difference between sqlaserver2000 and 2005
How to perform a loop through all tables in pl/sql?
Why do we use joins in sql?
What is the difference between a procedure and a function?
What is pl sql script?
What is serial sql?
What is pl sql code?
Can a primary key be a foreign key?
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)