Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Invoke the Original Export Import Utilities
How To Invoke the Original Export Import Utilities? - Oracle DBA FAQ - Loading and Exporting Data
✍: FYIcenter.com
If you really want to run the original export import utilities, you can still go to "bin" directory of the Oracle server path and run the "exp" or "imp" command. The tutorial exercise below tells you how to run the export and import utilities in help modes:
>cd \oraclexe\app\oracle\product\10.2.0\server\BIN >exp help=y You can let Export prompt you for parameters by entering the EXP command followed by your username/password: Example: EXP SCOTT/TIGER Or, you can control how Export runs by entering the EXP command followed by various arguments. To specify parameters, you use: Format: EXP KEYWORD=value or KEYWORD=(value1,value2,...,valueN) Example: EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP,DEPT,MGR) or TABLES=(T1:P1,T1:P2), if T1 is partitioned table ...... >imp help=y ......
2007-05-02, 4667👍, 0💬
Popular Posts:
What is CMM and different levels? explain? The Capability Maturity Model (CMM) is a process capabili...
What exactly happens when ASPX page is requested from Browser? Note: - Here the interviewer is expec...
What is difference between custom JSP tags and JavaBeans? Custom JSP tag is a tag you defined. You d...
How can we suppress a finalize method? GC.SuppressFinalize ()
How to make elements invisible? Change the "visibility" attribute of the style object associated wit...