RE: how to specify tablespace in Designer

2003-10-24 Thread TOMPKINS, MARGARET
Have you got into Oracle SCM yet? It's an even more amazing beast! Maggie Respectfully, > Maggie Tompkins - CAD SQA > Corporate Applications Division > Technology Services Organization - Kansas City > Defense Finance and Accounting Service > 816-926-1117 (DSN 465); [EMAIL PROTECTED] -Origi

RE: how to specify tablespace in Designer

2003-10-24 Thread Ben
Hats off and thanks to all for the great responses. I am well on my way now. This Designer beast is quite amazing. Ben -Original Message- Sent: October 23, 2003 2:02 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Ben, You need to implement the table to assign storage attributes to

Re: how to specify tablespace in Designer

2003-10-24 Thread Jared Still
The odtug lists are interestingly enough, hosted by fatcity.com. Here is the complete list of fatcity lists: # ## ## ## --> LIST OF MAILING LISTS

RE: how to specify tablespace in Designer

2003-10-24 Thread TOMPKINS, MARGARET
Just go to the Oracle Development Tools User Group (ODTUG) web site at www.odtug.com and you will see a link to the list serves. Just click on the Designer list, or Developer, or anything else that you would like. They're great lists and they're free. Maggie Respectfully, > Maggie Tompkins -

RE: how to specify tablespace in Designer

2003-10-24 Thread Mercadante, Thomas F
sundeep, are you saying that the people who responded to this question are not "real experts"? where do you live? look out your front door. that's me with a baseball bat! :) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 23, 2003 9:44 PM To:

RE: how to specify tablespace in Designer

2003-10-24 Thread Boivin, Patrice J
Where is the designer-L list? Patrice. -Original Message- Sent: Thursday, October 23, 2003 10:44 PM To: Multiple recipients of list ORACLE-L Ben, If you had posted this question to designer-L you'd have gotten insight from some real experts. In designer table definition(table columns,

RE: how to specify tablespace in Designer

2003-10-23 Thread TOMPKINS, MARGARET
Ben, I really prefer to do this in the RON or in the Server Model tab of Design Editor. However, in Design Editor, DBAdmin tab, expand the container that has your table, then expand the Oracle Database that contains the table, and expand the User. For us, that is the schema owner. Under th

Re: how to specify tablespace in Designer

2003-10-23 Thread sundeep maini
Ben, If you had posted this question to designer-L you'd have gotten insight from some real experts. In designer table definition(table columns, indexes, keys, constraints) is different from table implementation(schema, tablespace, storage parameters). The same table definition can be associated

Re: how to specify tablespace in Designer

2003-10-23 Thread Brian Haas
Ben wrote: Hi Can someone who has used Designer to generate DDL let me know how you specify which tablespace a table or index is to be created in. I am using the Design Editor and the DBAdmin tab and can't seem to find it. Thanks in advance. Ben Ben, Under the DBadmin tab->schema objects->table

RE: how to specify tablespace in Designer

2003-10-23 Thread Mercadante, Thomas F
Ben, You need to implement the table to assign storage attributes to it. This can be done either in the Ron or Db Designer where you are at. In Db Designer/DbAdmin tab, expand the database|Users|spcific User|Schema|Table Implementations entry. Click the green plus to implement a table in this a