can any one help me with import/export options in
oracle............
- 1 Answers
- 5271 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 |
How do I use os authentication with weblogic jdriver for oracle and connection pools?
a query to select maxmun 3 salaries of employee table
How to convert a date to char in oracle? Give one example.
3. Display all the client numbers in the ORDER table. Remove duplicates.
how to get count of tables in particular database in Oracle?
How can windows applications connect to oracle servers?
What is the difference between 10g OEM and 11g OEM?
What is a SNAPSHOT ?
i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table
What is object data modeling?
how to truncate date and get only time part 9:20:00
How to count duplicated values in a column in oracle?
Oracle General 
