Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: how to specify tablespace in Designer
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 implementaions
right click the table in question,go to properties and the first item on the storage tab allows you to select a tablespace provided you've created the definitions for your tablespaces.
-Brian
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Haas INET: bhaas_at_musiciansfriend.com 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 Thu Oct 23 2003 - 19:04:26 CDT
![]() |
![]() |