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 |
How do you optimize a stored procedure in sql?
What is rownum in sql?
How do you change a value in sql?
what is the difference between nested subquery and correlated subquery?
Can a table contain multiple foreign key’s?
what is the difference between sql and t-sql? : Transact sql
Explain normalization and what are the advantages of it?
What does seeding a database mean?
IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????
What is an index in sql with example?
What is plpgsql language?
What is a database link?
Oracle (3253)
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)