oracle export / import command

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 […]

Maximum Availability Architecture – Oracle Streams Configuration Best Practices

Oracle doc PDF URL : http://dn.monster.tw/my/docs/oracle/MAA_10gR2_Streams_Configuration.pdf Oracle® Streams Advanced Queuing User’s Guide and Reference 10g Release 2 (10.2) – http://download.oracle.com/docs/cd/B19306_01/server.102/b14257/toc.htm sample memo: http://www.monster.com.tw/archives/2565 Oracle Maximum Availability Architecture – Overview – http://www.oracle.com/technology/deploy/availability/htdocs/maaoverview.html