can any one help me with import/export options in
oracle............
Answer Posted / 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 |
Post New Answer View All Answers
Whether any commands are used for months calculation? If so, what are they?
Name the various constraints used in oracle?
Please explain oracle left join with an example?
What is the difference between I and G in Oracle?
Point the difference between translate and replace?
Explain user account with reference to oracle.
What are temporal data types in oracle?
Respected sir, Please send me technical questions related to oracle apps..
What are the set operators union, union all, minus & intersect meant to do?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Explain the use of ignore option in imp command.
How to change program global area (pga) in oracle?
How to do a full database export?
What happens to the indexes if a table is recovered?
How can windows applications connect to oracle servers?