Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Oracle Database + Options
Export/Import/SQL Loader & External Tables
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jan 14, 2013 5:59 AM by
Jan 12, 2013 5:41 AM
Hi all ,
oracle 11g.2 ASM with RAC under RHEL 5
we have 2 table same structure one of them is empty and the pther one is contain data
the vendor do the insert as select but i found he is wrong due to there duplicated ,
now i want to use export and then rename the table and then import
but i need with export do a condition
exp user/pass tables=MTR_EPPC_CALLED_DATA file=MTR_EPPC_CALLED_DATA.dmp query="where callstarttime >=to_date('01122012','ddmmyyyy')
and callstarttime <=to_date('31122012','ddmmyyyy')"
but it's seem the query take one condition how can i use this above condition in export ???
also my friend say there is way to insert with rowid is this possible ??? share with me or link.
This content has been marked as final.
Show 2 replies
Jan 12, 2013 10:03 AM
in response to
Use expdp, put your query condition in parfile rather than command line. RTFM for the syntax, it is extremely easy.
Jan 14, 2013 5:59 AM
in response to
thanks , it's work now.
Go to original post