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 |
if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?
Enlist some commands of dcl?
What is meant by system analysis?
Where is the data stored in a database?
What is the importance of database in an organization?
Is it possible to declare or create a cursor for update of table? If no tell me why?
What is database development process?
What database should I learn first?
what is s/w lifecycle?
What are different types of joins in the sql?
What is string in database?
dear sir please provide what question will be asked in bank it officer interview
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)