1. Open a command prompt on an NT OR Win2000 workstation in the lab with Oracle client software installed
2. From the command prompt, open the oracle export utility using the following general syntax “exp username/pwd@connect_string”. As an example
H:\>exp elvis/king @cs4
3. You should then receive a response similar to the following:
Export: Release 184.108.40.206.0 - Production on Thu May 9 16:47:39 2002
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Release 220.127.116.11.0 - Production
JServer Release 18.104.22.168.0 – Production
4. Press return to select the default fetch buffer size if prompted
Enter array fetch buffer size: 4096 > 4097
5. Name your export file including its path when prompted. In this example, the export file is named c:\junk\expdata.dmp
Export file: EXPDAT.DMP > c:\junk\EXPDATA.dmp
6. You will be prompted to select entire database, users or tables to export. Select Tables(3) and respond to the subsequent prompts as follows:
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 3
Export table data (yes/no): yes > y
Compress extents (yes/no): yes > n
7. The system will respond with something similar to the following
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character s
About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > dept
. . exporting table DEPT 7 rows exported
Table(T) or Partition(T:P) to be exported: (RETURN to quit) >
Export terminated successfully without warnings.
You can use the import utility to import the file to another oracle database or Oracle user account. The command for starting the import utility is “imp”.