can any one help me with import/export options in
oracle............
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 many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
Difference between an implicit & an explicit cursor.?
How to view the dropped tables in your recycle bin?
how to genarate random numbers in oracle for particular row?
Explain what are the type of synonyms?
What is the use of aggregate functions in oracle?
what are the advantages of running a database in archive log mode?
What is ASM (Automatic Storage Management) in Oracle?
What is PL/SQL ?
How to invoke the data pump export utility?
Difference between primary key and unique key ?
77 Answers Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,