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 |
What is the difference between substr and instr?
various types of joins
1.display list of all users from ur data base.what is the query?
What is a lookup table in oracle?
what are the things that you consider while creating indexes on partitioning tables?
How to unlock the sample user account in oracle?
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?
What is an index associated with a constraint?
How to shutdown your 10g xe server?
DBMS vs. RDBMS
When can Hash Cluster used ?
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?