Interested to Buy Any Domain ? << Click Here >> for more details...
can any one help me with import/export options in
oracle............
- 1 Answers
- 5716 Views
- I also Faced
- E-Mail Answers
Answer / pugal
The following examples demonstrate how imp/exp can be used:
exp scott/tiger file=emp.dmp log=emp.log
tables=emp rows=yes indexes=no
exp scott/tiger file=emp.dmp tables=(emp,dept)
imp scott/tiger file=emp.dmp full=yes
imp scott/tiger file=emp.dmp fromuser=scott
touser=scott tables=dept
exp userid=scott/tiger@orcl parfile=export.txt
... where export.txt contains:
BUFFER=100000
FILE=account.dmp
FULL=n
OWNER=scott
GRANTS=y
COMPRESS=y
NOTE: If you do not like command line utilities, you can
import and export data with the "Schema Manager" GUI that
ships with Oracle Enterprise Manager (OEM).
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the commands youd issue to show the explain plan for select
What is difference between SQL and SQL*PLUS?
How to open a cursor variable?
How to define an explicit cursor in oracle?
How to generate query output in html format?
Explain what are the characteristics of data files?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
what are views?
How to rollback the current transaction in oracle?
What is indexing, and how does it improve performance?
What is a connect identifier?
Oracle General 
