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 Mike Lewis 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
Jul 23, 2003
5
0
0
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
How can i generate serial nos in reports
Replies
1
Views
13
nagornyi
nagornyi
bookouri
  • Locked
  • Question
generate a sequence number
Replies
0
Views
14
bookouri
bookouri
sweng
  • Locked
  • Question
designer -generate
Replies
2
Views
21
sweng
sweng
indie75
  • Locked
  • Question
How to only generate a LOV once, then re-use?? 1
Replies
2
Views
11
sem
sem
noMoreHandles
  • Locked
  • Question
Support for dimension objects and DDL in Designer 9i?
Replies
0
Views
13
noMoreHandles
noMoreHandles

Part and Inventory Search

Sponsor

Back
Top