export table partition???????
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: export table partition???????

  1. #1
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    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.

  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    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'

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I think the syntax is:
    exp u/p file=xxx.dmp tables=owner.table:part_name
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Mar 2002
    Posts
    534

    Wink

    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

  5. #5
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    Thanks folks..
    Thanks.
    Thanigaivasan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width