Interested to Buy Any Domain ? << Click Here >> for more details...
can any one help me with import/export options in
oracle............
- 1 Answers
- 5869 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 advantages of running a database in NO archive log mode?
How to create a stored program unit?
What are the different types of failures that occur in Oracle database?
how to see the data (in unix) using dataset in datastage?
How to create a temporary table in oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
How to bring a tablespace offline?
What are the Limitations of a CHECK Constraint ?
What are oracle functions?
How to create id with auto_increment on oracle?
What is oracle join syntax?
How to connect to the server with user account: sys?
Oracle General 
