| 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
The odtug lists are interestingly enough, hosted by fatcity.com.
Here is the complete list of fatcity lists:
#####################################################################
##
##
## --> LIST OF MAILING LISTS CARRIED BY FATCITY.COM
##
##
##
##################################################################### Mailing List Description List Name Moderated?Closed?
The Chip Directory chipdir-L NoNo
Oracle Development Tools Users Group odtug-L No No
ODTUG Data Warehousing odtug-warehouse-L No No
ODTUG Methodology odtug-methods-L No
No
ODTUG Designer/2000 odtug-des2k-L No
No
ODTUG Developer/2000 odtug-dev2k-L No
No
ODTUG Discoverer/2000 odtug-disc2k-L No
No
ODTUG SQL*Plus odtug-sqlplus-L No
No
ODTUG Java/JDeveloper odtug-java-L No
No
ODTUG Web Development odtug-webdev-L No
No
ODTUG Board Members odtug-board-L No
Yes
ODTUG Conference Committee odtug-confcomm-L No
Yes
ODTUG Membership Committee odtug-memcomm-L No
Yes
ODTUG Designer Committee odtug-descomm-L No
Yes
ODTUG Conference Parents Connect odtug-conf-parents-L
No No
ODTUG IOUG Coordination list odtug-ioug-L No
Yes
ODTUG Business Rules odtug-rules-L No No
Oracle on Linux oracle-linux-L No
No
Oracle DBA Mailing List oracle-L No No
Rocky Mountain Oracle Users Group rmoug-L No
No
RMOUG Miscellanous Content rmoug-misc-L No
No
RMOUG Board Members rmoug-board-L No
Yes
ListGuru Software Info listguru-L No No ListGuru Administrators Mailing List listguru-admins-L NoYes
OpenGL Game Programming List opengl-gamedev-L No
No
OpenGL Advocacy Mailing List opengl-advocacy-L No
No
OpenAL Development List openal-dev-L NoNo
Infinite Worlds Developers list iw-dev-L No
Yes
Infinite Worlds Prayer list iw-prayer-L No
Yes
Bridge Medical Point of Care Newsletter point-of-care-L No No Bridge Medical Press Releases bidge-news-L NoYes
Pacific Graduate School of Psychology pgsp-L No No
Voyageurs-L discussion list voyageurs-L No Yes
Flight Attendants Association of Australia
FAAA Qantas Long Haul List faaa-qantas-long-L
FAAA Qantas Short Haul List faaa-qantas-short-L
FAAA Ansett Domestic List faaa-ansett-dom-L
FAAA Ansett Internaional List faaa-ansett-intl-L
FAAA Southern Airlines List faaa-southern-L
FAAA Eastern Airlines List faaa-eastern-L
FAAA Flight West List faaa-flight-west-L
FAAA Hazelton Airlines List faaa-hazelton-L
FAAA Kendall Airlines List faaa-kendall-L
FAAA Lloyds Aircrew List faaa-lloyds-L
FAAA National Jet Systems List faaa-national-jet-L
FAAA Sunstate List faaa-sunstate-L
FAAA Skywest List faaa-skywest-L
NOTE: All lists in the FAAA- category are announce-only, private
lists.
Animatronics (robotics, puppets, etc) animatronics-L No No
On Thu, 2003-10-23 at 18:44, sundeep maini wrote:
> 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 with many different table
> implementation (e.g. different storage for the same table depending
> on test, prodction environment etc).
>
> In design editor's db admin tab you need to define database (under
> your application folder) then tablespace and/or storage definitions
> and users under that database. You also need to give users quota on
> tablespaces.
>
> Now generate the table DDL while in D Admin tab. Your DDL will now
> contain the all the artifacts.
>
> This is tedious process if you have large set of tables. If you want
> to do it repeatedly, create the database, tablespace, user and quotas
> ahead of time. While converting your ER model (you use ER modeler
> right?) using database design transformer, you can specify the table
> space for table and indexes. The transformer will create both table
> definitions and table implementations for you. Then from Design
> Editor's DB Admin tab you generate DDL for for your tables.
>
>
> --- Ben <poelsb_at_post.queensu.ca> 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
> > --
> > 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).
>
>
> =====
>
> Sundeep Maini
> Consultant
> Currently on Assignement at Caterpillar Peoria
> sundeep_maini_k_at_cat.com
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: sundeep maini
> INET: sundeep_maini_at_yahoo.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).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: jkstill_at_cybcon.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 Fri Oct 24 2003 - 14:09:31 CDT
 |
 |