Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 29-05-2009
Member
 
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
Reply With Quote
  #2  
Old 29-05-2009
Member
 
Join Date: May 2008
Posts: 2,383
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.
Reply With Quote
  #3  
Old 29-05-2009
Member
 
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Get ddl of schema from toad"
Thread Thread Starter Forum Replies Last Post
Connect To Remote Oracle Database with Toad Eashta^devata Software Development 2 30-08-2011 11:09 PM
Schema Admins AngerEyes Active Directory 1 22-05-2011 03:57 AM
Schema in SQL2 \"Dritan\" Software Development 3 11-01-2011 08:26 AM
Don't know about XML schema ScarFace 01 Software Development 5 04-02-2010 09:20 AM


All times are GMT +5.5. The time now is 01:21 AM.