Can we export only one table partition?.
meaning we have a table partioned t1,t2,t3,t4,t5...like that.
I want to export only t2.Is it possible???.All in same tablespace...
Thanks in advance.
I believe if you fully qualify the table name/partition name it is.
Try something like full=n, tables=(table.partition_name)
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'
I think the syntax is:
exp u/p file=xxx.dmp tables=owner.table:part_name
Have a look at transportable tablespaces in many cases it's realy usefull and much faster then an import/export.
Click Here to Expand Forum to Full Width