 | |
Newbie: Creating new database files
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#21
 
| |||
| |||
|
Re: Newbie: Creating new database files -
11-09-2006
, 05:11 PM
|
"joel garry" <joel-garry (AT) home (DOT) com> wrote in message news:1163015064.594954.281400 (AT) h48g2000cwc (DOT) googlegroups.com... Ade wrote: Hi, to answer your question, COBOL, C, Basic, Fortran, Macro Assembler and Powerhouse What, no BLISS? :-) No I don't have separate disks on my home PC. The main reason here is to keep the database files for each application away from other apps. I have learnt quite a bit about tablespaces over the last week or so, especially the fact that Oracle 10g Express won't, in itself, let you create any within the GUI. However, using the SQLPLUS that comes along with it is a different matter. In that you can manipulate the entities (for want of a better word) a whole lot better. I still can't find the command to extend a file once created though. I initially entered the following; SQL> create tablespace datafile 'c:\trash\my_tablespace.dbf' size 200000; I then had a look in the directory and saw the 200,000 byte file (I was kind of expecting it in 512 byte blocks - oh well that's VMS for ya!) so I decided to try to extend it but couldn't find the command. Looking on the web, I have found that you should initialize to what you think should last for a while and include the extend clause in the create statement. Still wouldn't mind a single command to extend it though. Brian and Charles gave you the command, but I would add you want to familiarize yourself with how to find this stuff in the docs. Decoding the sql syntax as presented in the manual is a skill in itself, but a necessary one. http://tahiti.oracle.com is a fairly decent search engine, including a list of books if you know which one to go to. In this case, you need the SQL Reference and see Alter Tablespace. Of course, you should read the Concepts and 2-Day DBA if you haven't already. Some other resources here: http://www.dbaoracle.net/readme-cdos.htm I remember the first time seeing a complete set of V3 VMS manuals at a Datatrieve training class, set up linearly on a table that stretched along an entire wall. Ah memories... jg -- @home.com is bogus. http://williambader.com/museum/vax/vaxhistory.html Thanks for the pointers, I'll have a look as soon as I can. I also intend spending a wad of cash on some decent manuals on SQL /PLSQL relevant to the version I have. |
http://asktom.oracle.com/pls/ask/f?p...6862949325::NO
Quote:
|
The only BLISS I have seen was in source code listings of VMS 6.2 - interesting stuff (honest!!). It's now on the freeware CD if you're interested and have a microvax or small Alpha in your garage. |
Quote:
|
Datatrieve - I remeber that - did you ever see the help under WOMBAT on a graphics terminal?? |
jg
--
@home.com is bogus.
http://www.npd.ufes.br/TenLaws.htm
#22
| |||
| |||
|
|
Ade wrote: "joel garry" <joel-garry (AT) home (DOT) com> wrote in message news:1163015064.594954.281400 (AT) h48g2000cwc (DOT) googlegroups.com... Ade wrote: Hi, to answer your question, COBOL, C, Basic, Fortran, Macro Assembler and Powerhouse What, no BLISS? :-) No I don't have separate disks on my home PC. The main reason here is to keep the database files for each application away from other apps. I have learnt quite a bit about tablespaces over the last week or so, especially the fact that Oracle 10g Express won't, in itself, let you create any within the GUI. However, using the SQLPLUS that comes along with it is a different matter. In that you can manipulate the entities (for want of a better word) a whole lot better. I still can't find the command to extend a file once created though. I initially entered the following; SQL> create tablespace datafile 'c:\trash\my_tablespace.dbf' size 200000; I then had a look in the directory and saw the 200,000 byte file (I was kind of expecting it in 512 byte blocks - oh well that's VMS for ya!) so I decided to try to extend it but couldn't find the command. Looking on the web, I have found that you should initialize to what you think should last for a while and include the extend clause in the create statement. Still wouldn't mind a single command to extend it though. Brian and Charles gave you the command, but I would add you want to familiarize yourself with how to find this stuff in the docs. Decoding the sql syntax as presented in the manual is a skill in itself, but a necessary one. http://tahiti.oracle.com is a fairly decent search engine, including a list of books if you know which one to go to. In this case, you need the SQL Reference and see Alter Tablespace. Of course, you should read the Concepts and 2-Day DBA if you haven't already. Some other resources here: http://www.dbaoracle.net/readme-cdos.htm I remember the first time seeing a complete set of V3 VMS manuals at a Datatrieve training class, set up linearly on a table that stretched along an entire wall. Ah memories... jg -- @home.com is bogus. http://williambader.com/museum/vax/vaxhistory.html Thanks for the pointers, I'll have a look as soon as I can. I also intend spending a wad of cash on some decent manuals on SQL /PLSQL relevant to the version I have. http://www.stevenfeuerstein.com/puter/plsql.htm http://asktom.oracle.com/pls/ask/f?p...6862949325::NO The only BLISS I have seen was in source code listings of VMS 6.2 - interesting stuff (honest!!). It's now on the freeware CD if you're interested and have a microvax or small Alpha in your garage. Naw, just a couple of PDP's in the basement! Datatrieve - I remeber that - did you ever see the help under WOMBAT on a graphics terminal?? http://www.ibphoenix.com/main.nfs?a=...age=ibp_wombat jg |
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.