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

Thread: how do i extract this alone from export file...

Hybrid View

  1. 02-18-2003, 04:50 AM #1
    fordikon
    fordikon is offline Member
    Join Date
    Apr 2001
    Posts
    126

    Angry how do i extract this alone from export file...

    How do i extract procedures / triggers /views alone from
    export dump.
    Reply With Quote Reply With Quote
  2. 02-18-2003, 04:54 AM #2
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    You could use imp userid=system/manager file=expdat.dmp rows=n indexes=n full=y indexfile=mysource.sql log=mylog.log

    The mysource.sql will contain the all the DDL for you ..you can grep for triggers,proceedures etc..

    regards
    Hrishy
    Reply With Quote Reply With Quote
  3. 02-18-2003, 07:37 AM #3
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by hrishy
    The mysource.sql will contain the all the DDL for you ..you can grep for triggers,proceedures etc..
    No, the indexfile does not contain any PL/SQL code. It only contains CREATE statements for tables (commented) and their corresponding indexes.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
  4. 02-19-2003, 02:30 AM #4
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Jmodic

    That was faux-paus from my side..i am sorry..you are right..He should be using toad or soemthin for that

    regards
    Hrishy
    Reply With Quote Reply With Quote
  5. 02-19-2003, 05:31 AM #5
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Another option is to use the freeware databee tool, this will generate the required scripts

    http://www.databee.com/dt_home.htm

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  6. 02-19-2003, 05:39 AM #6
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Thumbs up

    yep thats an excellent tool...

    removed a lot of headach...
    the HTML output can be deployed on a webserver (i use apache)

    helps in checking the database structure...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    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