Sunday, January 7, 2018

Table Export in oracle 12c Database

conn strerp/strerp@kayum1

SQL> host exp

Export: Release 12.2.0.1.0 - Production on Mon Jan 8 14:49:53 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.


Username: strerp/strerp@kaium

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Enter array fetch buffer size: 4096 >

Export file: EXPDAT.DMP > E:\12c_DMP\STARERP-08-01-2018.dmp

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

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

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

About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > strerp_user_info

. . exporting table               STRERP_USER_INFO          2 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > strerp_menu_info

. . exporting table               STRERP_MENU_INFO         25 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > strerp_repserver12c

. . exporting table            STRERP_REPSERVER12C          1 rows exported
EXP-00091: Exporting questionable statistics.
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > strerp_user_menu

EXP-00011: STARERP.STRERP_USER_MENU does not exist
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > strerp_user_module

. . exporting table             STRERP_USER_MODULE         37 rows exported
EXP-00091: Exporting questionable statistics.
Table(T) or Partition(T:P) to be exported: (RETURN to quit) >

Export terminated successfully with warnings.








No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...