Monthly Archives: July 2010

Export & Load some table in DB2

How can I export / Import some table in DB2 on command prompt

C:\Program Files\IBM\SQLLIB\BIN>db2
(c) Copyright IBM Corporation 1993,2002
Command Line Processor for DB2 ADCL 9.1.0

You can issue database manager commands and SQL statements from the command
prompt. For example:
db2 => connect to sample
db2 => bind sample.bnd

Continue reading


exp / imp some table in Oracle

How can I export / Import some table in Oracle on command prompt

C:\Documents and Settings\david>exp ods0_mart_postpaid/ods0_mart_postpaid@cognos file=dim_region.dmp tables=dim_region log=dim_region.log

Export: Release 10.2.0.1.0 – Production on Mon Jul 5 17:12:42 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.

Continue reading