Results 1 to 3 of 3

Thread: Get ddl of schema from toad

  1. #1
    Join Date
    Mar 2009
    Posts
    34

    Get ddl of schema from toad

    hi,
    I have granted permission to newly created schema/user.with oracle 10g i am using toad to connect it.I want to create table structure by generating DDL scripts, How can get the DDL script using Toad .can some one help me ?
    thank you

  2. #2
    Join Date
    May 2008
    Posts
    2,389

    Re: Get ddl of schema from toad

    if you want schema level as opposed to object level you normally must need the database Admin module try this right click the object in the schema browser, select create in another schema.The a DDL options window will display , select the options , then click OK that will take you to another dialog now you can choose the destination schema.With this you can select again also,close when done.

  3. #3
    Join Date
    Aug 2007
    Posts
    1,098

    Re: Get ddl of schema from toad

    open abc.sql after connecting to the schema in which you want to get DDL in toad and click at execute script option.If this file available at C:\ check it and then try @C:\Users\user_xyz\abc.sql check extension and the file name.

Similar Threads

  1. Connect To Remote Oracle Database with Toad
    By Eashta^devata in forum Software Development
    Replies: 2
    Last Post: 30-08-2011, 11:09 PM
  2. Schema Admins
    By AngerEyes in forum Active Directory
    Replies: 1
    Last Post: 22-05-2011, 03:57 AM
  3. Schema in SQL2
    By \"Dritan\" in forum Software Development
    Replies: 3
    Last Post: 11-01-2011, 08:26 AM
  4. Don't know about XML schema
    By ScarFace 01 in forum Software Development
    Replies: 5
    Last Post: 04-02-2010, 09:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,859,308.71647 seconds with 16 queries