You can use QUERY parameter in export utility. You can only do table-mode export if you want to use this parameter. You can read about using QUERY parameter here
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#sthref2328 OR If you partition the tables you want to export based on the financial years, you can just use TABLES parameter. Specifying the table name and the partition you want to export. Read about it here.. http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#sthref2358 Try and if you've got problem, post your question here. On Dec 4, 2007 4:22 PM, mm kk <[EMAIL PROTECTED]> wrote: > i want to execlude all data in all table that are in determined > financial years > such that orders table contain data with financial year > (2003,2004,2005,2006,2007) > i want to take dump file with data that are in financial > year(2005,2006,2007) only > im user oracle 9i , 10g > and i want to use export utility > > Yoel Susanto <[EMAIL PROTECTED] <yoel.ade%40gmail.com>> wrote: > Hi mm kk, > > Please tell us your oracle version. > Do you want to use data pump or export utility? > What's the table name you want to exclude? > > Cheers > > On 12/1/07, mm kk <[EMAIL PROTECTED] <mm_kk434%40yahoo.com>> wrote: > > how can i take db dump file from db with all data and except data with > > financial year ? > > > > --------------------------------- > > Never miss a thing. Make Yahoo your homepage. > > > > [Non-text portions of this message have been removed] > > > > > > --------------------------------- > Never miss a thing. Make Yahoo your homepage. > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
