RE: Installation

Santosh,

Ok, first thing I recommend is getting onto a supported version! Try 9.2.0.1. I know, this may be well out of your control, but it bears mentioning. 8.1.5 is no longer supported by Oracle. You should be on at least 8.1.7.4, perferably 9.2.0.1, as 8.1.7.4 is de-supported in about 14 months.

Now, on to creating a tablespace:

The basic command syntax is:

create tablespace <tablespace name> datafile '/path/to/datafile_name' size <size of datafile in bytes>;

Optionally, you could (probably should) specify a storage clause. Also, although 8.1.5 may be a problem, (not sure, there were lots of bugs in 8.1.5), you should use locally managed tablespaces with uniform extents. That can be done with the 'extent management local uniform' clause.

That is the barest minimum of information. If my impression is correct, and you have little or no previous Oracle knowledge, then some of the terms I mentioned: "storage clause", "locally managed tablespace" may be unfamiliar to you. If that's the case, I strongly suggest a good beginning DBA book, and perhaps an introductory class.

At a minimum, I recommend that you go to http://otn.oracle.com/ and sign up for a free account.

Then, go to:
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76965/toc.htm and read it all. Yes, all.

Finally, for specific info on the create tablespace command, see:

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/statem4c.htm

Again, not trying to be rude, but Oracle is a HUGE subject. This is a great forum for getting questions answered. It's not practical as a forum to teach you Oracle.

Ok, that's enough...it's now 3:00am in this timezone, and I gotta work tomorrow. G'night all.

Hope that helps in some small way,

-Mark

On Tue, 2002-10-22 at 02:48, Santosh Varma wrote:
> u r right Mark.
>
> as regards version, i am using 8.1.5
>
> I will come down to asking how to create the tablespace...
>
> santosh
>
> -----Original Message-----
> Bobak
> Sent: Tuesday, October 22, 2002 11:48 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Santosh,
>
> I don't mean to be rude here, and there are lots of people, including
> myself, who try to be helpful. But, it's simply not possible to give a
> list of "what all needs to be installed."
> It's like showing up in a room full of construction workers and saying,
> "Hi, I'm about to start building my house, but I've never done this
> before. Can you please give me a list of things I need to do and
> pointers as to what I need to look out for?"
>
> If you have specfic issues or problems, or if a particular concept is
> not clear, I'm sure there are many who would be willing to help. Ask
> specific questions, you'll get specific answers.
>
> Also, always specify O/S, O/S version, and Oracle version. Oracle is a
> constantly moving target. It's impossible to give a clear and complete
> answer without that.
>
> Hope that helps,
>
> -Mark
>
> On Tue, 2002-10-22 at 01:13, Santosh Varma wrote:
> >
> > it is a telecom product.
> > i am asking about any oracle specific installations..
> > like tables,indexes,tablespaces etc.
> >
> > i hope i am clear
> > santosh
> >
> > -----Original Message-----
> > WILLIAMS
> > Sent: Monday, October 21, 2002 8:49 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Santosh - Let me understand . . . Oracle is already installed and in
> > production at this site? Are you installing a commercial product? Then you
> > should probably follow the instructions that come with the product. If it
> is
> > a quality product with quality instructions, then tablespaces, etc. will
> be
> > dealt with. If this is a production site, you should definitely install
> this
> > on their test system first, probably after backing up the test system. Am
> I
> > missing something here with your situation?
> >
> >
> >
> > Dennis Williams
> > DBA, 40%OCP
> > Lifetouch, Inc.
> > dwilliams_at_lifetouch.com
> >
> > -----Original Message-----
> > Sent: Monday, October 21, 2002 5:38 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hello all,
> >
> > I am going to install a product in a client's place where oracle is
> > installed.
> > I am new to oracle. I wanted to know what all needs to be installed .. i
> > mean like tables,tablespace etc... Please give me a list of these and how
> to
> > do in brief
> >
> > Thanks and regards,
> >
> > Santosh
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: DENNIS WILLIAMS
> > INET: DWILLIAMS_at_LIFETOUCH.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).
> >
> --
> --
> Mark J. Bobak
> Oracle DBA
> mark_at_bobak.net
> "It is not enough to have a good mind. The main thing is to use it
> well."
> -- Rene Descartes
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark J. Bobak
> INET: mark_at_bobak.net
>
> 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).
>

-- 
--
Mark J. Bobak
Oracle DBA
mark_at_bobak.net
"It is not enough to have a good mind.  The main thing is to use it
well."
 						-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  INET: mark_at_bobak.net

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