| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: how to specify tablespace in Designer
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: 'ORACLE-L_at_fatcity.com'
Cc: 'poelsb_at_post.queensu.ca'
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 area, and you should see the properties attribute pop up. Optionally right click on the Table Implementations selection and select "Create Table Implementations".
Good Luck!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Thursday, October 23, 2003 2:45 PM
To: Multiple recipients of list ORACLE-L
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ben
INET: poelsb_at_post.queensu.ca
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ben
INET: poelsb_at_post.queensu.ca
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 24 2003 - 15:19:24 CDT
 |
 |