Need urgent for sequence export with par file
825320Dec 20 2010 — edited Dec 20 2010Hi All,
I am new for oracle DB. I need urgent help. I am currently exporting tables from par file.
Below is my par file description:
---------------------------------------
STATISTICS=NONE
BUFFER=1000000
GRANTS=N
tables=TB_EPC_ELEMENT
TB_ENTITY_STORE
TB_COMPILED_RULES
EFFECTIVE_VERSION
-------------------------------------------
This same is also used for import also.
Now I want to export and import sequence also through this par file.
I have also tried below mentioned options:
----------------------------------------
STATISTICS=NONE
BUFFER=1000000
GRANTS=N
INCLUDE=SEQUNCE,TABLE:" IN('TB_EPC_ELEMENT','TB_ENTITY_STORE','TB_COMPILED_RULES',
'EFFECTIVE_VERSION',
'EFFECTIVE_VERSION_SQ')"
----------------------------------------
But It's giving exception.
Please provide some help or pointer regarding it. Thanks in advance.
Regards,
Gopal lal