Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Generate DDL

Status
Not open for further replies.
morgface

morgface

Technical User
Joined
Jul 23, 2003
Messages
5
Location
US
Hello,

I am currently testing out Oracle Designer 9.0.4.5 and have got a bit stuck.

I have managed to get a model into the Design Editor, I have worked out how to generate the DDL from the "Generate database from Server Model". The problem that I have is, that when it generates the Create Table, Create Index and Create Constraint statements, I really need it to include the schema owner i.e.

Create table schema_owner.table_name etc...

I cannot for the life of me work out how to do this... I might be being really dumb, but I feel I have tried everything. Can anyone please tell me what I am missing??

Many thanks,

Sarah
 
Status
Not open for further replies.

Similar threads

amir4oracle
  • Locked
  • Question Question
How can i generate serial nos in reports
Replies
1
Views
141
nagornyi
nagornyi
bookouri
  • Locked
  • Question Question
generate a sequence number
Replies
0
Views
135
bookouri
bookouri
sweng
  • Locked
  • Question Question
designer -generate
Replies
2
Views
166
sweng
sweng
indie75
  • Locked
  • Question Question
How to only generate a LOV once, then re-use??
Replies
2
Views
169
sem
sem
noMoreHandles
  • Locked
  • Question Question
Support for dimension objects and DDL in Designer 9i?
Replies
0
Views
122
noMoreHandles
noMoreHandles

Part and Inventory Search

Sponsor

Back
Top