joel garry wrote:
> Ade wrote:
>> "joel garry" <joel-garry_at_home.com> wrote in message
>> news:1163015064.594954.281400_at_h48g2000cwc.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=4950:4:8084266306862949325::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=ibphoenix&page=ibp_wombat
>
> jg
What will you take for one of them? <g>
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Nov 09 2006 - 17:55:47 CST
