| is there a way to script a schema without toad?? [message #130413] |
Fri, 29 July 2005 20:18  |
gdeconto
Messages: 41
Registered: June 2005
Location: Vancouver, British Columb...
|
Member |
|
|
being fairly new to oracle, I have been using the free version of toad to work with oracle.
that version does not have a facility for scripting the schema (ie tables, views, stored procedures, functions, sequences, triggers, ...) to a text file.
is there an alternative (that is still free) to toad for this??
any help appreciated.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: is there a way to script a schema without toad?? [message #130458 is a reply to message #130455] |
Sat, 30 July 2005 14:25  |
gdeconto
Messages: 41
Registered: June 2005
Location: Vancouver, British Columb...
|
Member |
|
|
off the top of my head:
since I am looking for a simple means of generating a text script(s) of any/all object(s) in a given schema, how about a simple tool to do exactly that??
ie: a menu entry in Enterprise Manager, in the Tools | Database Tools area, where you specify the schema and specify (via checkboxes) which objects in which schema that you want to create a script for ... and then creates a text file (your choice of name and location) that contains the script(s).
there are other products (toad, mssql, mysql, ...) that do this sort of thing right now. must mean that it is not that hard to do.
mind you, a better suggestion to Oracle might be to buy out Toadsoft and make toad a default part of the oracle installation. I get the impression that lots of people are using that product with oracle, so why not make things simpler for everyone??
[Updated on: Sat, 30 July 2005 14:28] Report message to a moderator |
|
|
|
| Re: is there a way to script a schema without toad?? [message #130487 is a reply to message #130458] |
Sun, 31 July 2005 06:51 |
William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK
|
Senior Member |
|
|
Ah, "simple" = "GUI" 
I've been meaning to install OEM for a while but haven't got around to it yet. Also I prefer PL/SQL Developer to TOAD and luckily my current employers agree (well, I think they actually prefer the price) so we don't have TOAD around. It can generate DDL but for anything serious I would trust DBMS_METADATA more - you never know what new Oracle feature is not fully supported by third party tools. For example, try it on an external table, or a list-partitioned index-organized materialized view and see what it produces.
Another approach might be to perform an export without data, then either import using the indexfile option or just strip the text out of the .dmp file.
[Updated on: Sun, 31 July 2005 06:52] Report message to a moderator |
|
|
|
|
|
| Re: is there a way to script a schema without toad?? [message #130494 is a reply to message #130487] |
Sun, 31 July 2005 11:12 |
gdeconto
Messages: 41
Registered: June 2005
Location: Vancouver, British Columb...
|
Member |
|
|
Thx for the replies, Will.
Hadn't seen PL/SQL Developer (too many things to do, too many tools, etc), but it looks interesting. I will download and try it out.
The answer to my original question appears to be "yes, you can use dbms_metadata if you only have a couple of objects to script, but no otherwise".
|
|
|
|
|
|
|
|
| Re: is there a way to script a schema without toad?? [message #131446 is a reply to message #130413] |
Sat, 06 August 2005 07:22 |
oraclejo
Messages: 50
Registered: July 2005
Location: Ammar
|
Member |
|
|
Oracle Designer
You can use it to create meta data information.
It creates scripts to build your database.
You can as well reverse engineer and existing database modify it and regenerate the scripts.
this is the way we do team development
Ammar Sajdi
www.e-ammar.com
Ammar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
