exp userid=user/password file=/path/database_$(date +%Y%m%d).dmp log=/path/database_$(date +%Y%m%d).log ROWS=Y
imp user/password file=database_20100914.dmp fromuser=user1 touser=user2 grants=n ignore=y feedback=1000000
2017.0716
imp tsdb/password file=TBL_STORE_DAY_2015_201703291490748896.dmp ignore=y feedback=1000000 FULL=y
root@ora11xe:/data# imp tsdb/password file=XXXX.dmp ignore=y feedback=1000000 FULL=y Import: Release 11.2.0.2.0 - Production on Mon Jul 17 20:16:45 2017 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production Export file created by EXPORT:V11.02.00 via conventional path Warning: the objects were exported by ZZZZ, not by you import done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses AL32UTF8 character set (possible charset conversion) export server uses UTF8 NCHAR character set (possible ncharset conversion) . importing ZZZZ's objects into TTTT . importing ZZZZ's objects into TTTT . . importing table "XXXX" .................................................. 50040378 rows imported Import terminated successfully without warnings.