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, 5324👍, 0💬
Popular Posts:
How To Blend a Color Layer to a Image? - PSP Tutorials - Fading Images to Background Colors with PSP...
I have 5 questions please give me the answer ,explanation,suggestions if any?? what is PMP(project m...
How To Calculate Expressions with SQL Statements? - MySQL FAQs - Introduction to SQL Basics There is...
What is the purpose of the wait(), notify(), and notifyAll() methods? The wait(),notify(), and notif...
How can I search for data in a linked list? Unfortunately, the only way to search a linked list is w...