DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to export just constraints & sequence?

  1. 12-01-2009, 10:15 AM #1
    amit.sehrawat
    amit.sehrawat is offline Junior Member
    Join Date
    Dec 2009
    Posts
    1

    How to export just constraints & sequence?

    Hi,

    I hope my query is in right forum

    I want to export constraints, sequences, indexes(not necessary), packages from a schema, but i do not want tables. can someone help in this regard?
    Reply With Quote Reply With Quote
  2. 12-01-2009, 10:22 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you cant with exp

    you will have to script around the source - or use a tool like toad which will do it for you
    Reply With Quote Reply With Quote
  3. 12-01-2009, 12:05 PM #3
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool SQL Developer

    Or also if you use SQL Developer (Free from Oracle), you can choose what objects to export.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width