Category:Frequently Asked Questions

From Oracle FAQ
Jump to: navigation, search

[oracle@localhost ~]$ exp

Export: Release 10.2.0.1.0 - Production on Tue Jun 2 13:17:09 2015

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Username: GPIL_LPROD Password:

Connected to: Oracle Database 10g Release 10.2.0.1.0 - 64bit Production Enter array fetch buffer size: 4096 >

Export file: expdat.dmp > /u03/oracle/BACKUP/GPIL_LPROD_2615.dmp

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U >

Export grants (yes/no): yes >

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in US7ASCII character set and AL16UTF16 NCHAR character set server uses AL32UTF8 character set (possible charset conversion)

About to export specified users ... User to be exported: (RETURN to quit) >

Export terminated successfully without warnings.