RE: how to specify tablespace in Designer

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); Margaret.Tompkins_at_dfas.mil

-----Original Message-----
Sent: Friday, October 24, 2003 3:19 PM
To: Multiple recipients of list ORACLE-L

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: TOMPKINS, MARGARET
  INET: MARGARET.TOMPKINS_at_DFAS.MIL

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).