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

Thread: help me

  1. #1
    Join Date
    Sep 2000
    Posts
    305
    is there any script from which u can
    get the create statement of your all objects in your database
    i.e tables, procedure ,sequence etc
    if it there then pls. tell me
    it is urgent
    thanks in advance


  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    You can do this by using exp/imp.

    exp .... ROWS=N ...

    imp .... SHOW=Y ...

    Hope this helps
    Gert

  3. #3
    Join Date
    Oct 2000
    Posts
    211
    Refer the CD that comes free with "Oracle Database Administration The essential Reference" Oreilly Publications. The CD has all the create object scripts (for tables, index,functions,triggers etc)
    Hope that will help.
    However, if you require for any particular object specify along with your mailId, so that i can mail you.
    Manjunath

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