Interested to Buy Any Domain ? << Click Here >> for more details...
can any one help me with import/export options in
oracle............
- 1 Answers
- 5799 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 is the difference between postgresql and oracle?
Explain what are clusters?
How to list all tables in your schema?
What are the differences between primary key and unique key?
Explain the use of record length option in exp command.
Who developed oracle & when?
What is a View ?
How to create index-by table in oracle?
what is the difference between sql& oracle?
What are set operators?
Does a Before form trigger fire when the parameter form is suppressed ?
How to run create database statement?
Oracle General 
