Hi Friends,
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.
Thanigaivasan.
Printable View
Hi Friends,
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.
Thanigaivasan.
I believe if you fully qualify the table name/partition name it is.
Try something like full=n, tables=(table.partition_name)
I think the syntax is:
exp u/p file=xxx.dmp tables=owner.table:part_name
Hi,
Have a look at transportable tablespaces in many cases it's realy usefull and much faster then an import/export.
http://otn.oracle.com/docs/products/...spor.htm#12010
Mike
Thanks folks..
Thanks.
Thanigaivasan