Thursday, October 2, 2008

Oracle export with query (where clause)

export NLS_LANG=american_america.WE8ISO8859P1
exp user/password file=SUBSCRIPTIONGROUPS.dmp tables=SUBSCRIPTIONGROUPS query=\"where system_profile_id \= 1770\"