what is the use of EXP command ?
Answers were Sorted based on User's Feedback
Answer / charu
EXP command is a utility used for transferring the
structure /the data/indexes/statistics/tables/tablepaces
from a database.
More info can be got from exp help=y
Example Command is
exp username/password file=/absolutepath/ex.dmp tables=
(t1,t2,t3) statistics=none rows=y
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / guest
EXP command stands for EXPORT.This is used to transfer data
from one database to another database.To check all the
options in your system go to Start->run-><<type>> cmd----
>enter
<<type>>exp ---------->enter
| Is This Answer Correct ? | 1 Yes | 5 No |
WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.
Can we update table which is created from view?
2 Answers IBM, Punjab National Bank,
Is there some bulk load or other way to import a lot of data fast?
Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?
Explain the classification of Database Management System?
What are the types of database servers?
What you know in mapping of erd to dfd?
What do you understand by unique key?
what is the difference between DBMS and RDBMS??
76 Answers Aon Hewitt, BlackRock, Infosys, ISB, Jawood, TCS,
Mention few case manipulation functions in sql
What is create database?
What do you understand by the view and mention the steps to create, update and drop a view?
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)