FAQ
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: Santosh Varma
INET: vsantosh_at_psi.soft.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).

Search Discussions

  • Igor Neyman at Oct 21, 2002 at 2:24 pm
    RTFM will help.

    Igor Neyman, OCP DBA
    ineyman_at_perceptron.com


    Original Message -----
    From: Santosh Varma
    To: Multiple recipients of list ORACLE-L
    Sent: Monday, October 21, 2002 6:38 AM
    Subject: Installation

    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: Igor Neyman
    INET: ineyman_at_perceptron.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).
  • Ray Stell at Oct 21, 2002 at 3:18 pm

    On Mon, Oct 21, 2002 at 02:38:22AM -0800, Santosh Varma wrote:
    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
    --

    I smell Darwin award! http://www.darwinawards.com/
    ===============================================================
    Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Ray Stell
    INET: stellr_at_cns.vt.edu

    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).
  • DENNIS WILLIAMS at Oct 21, 2002 at 3:18 pm
    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).
  • Santosh Varma at Oct 22, 2002 at 5:13 am
    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).

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Santosh Varma
    INET: vsantosh_at_psi.soft.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).
  • Naveen Nahata at Oct 22, 2002 at 5:58 am
    Santosh,

    Your problem is still not clear. Are you going to install the product which
    will also install tables etc. in an oracle database? Or it is an independent
    product and you just want to be sure that it can co-exist with oracle?

    Regards
    Naveen
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Naveen Nahata
    INET: naveen_nahata_at_mindtree.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 at Oct 22, 2002 at 6:18 am
    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).
  • Santosh Varma at Oct 22, 2002 at 6:33 am
    ok.
    i will make it clear.
    i am going to install the product which will also install
    tables/indexes/table space etc.

    can i have some scripts to do it or should i manually create the tables one
    by one ??

    -----Original Message-----
    Nahata
    Sent: Tuesday, October 22, 2002 11:28 AM
    To: Multiple recipients of list ORACLE-L

    Santosh,

    Your problem is still not clear. Are you going to install the product which
    will also install tables etc. in an oracle database? Or it is an independent
    product and you just want to be sure that it can co-exist with oracle?

    Regards
    Naveen

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Naveen Nahata
    INET: naveen_nahata_at_mindtree.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.com
    --
    Author: Santosh Varma
    INET: vsantosh_at_psi.soft.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).
  • Santosh Varma at Oct 22, 2002 at 6:48 am
    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).

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Santosh Varma
    INET: vsantosh_at_psi.soft.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 Richard at Oct 22, 2002 at 7:18 am
    Santosh,

    Oracle has an installation program which will create the internal tables,
    views, tablespaces, etc required to start Oracle. It will guide you
    through that process fairly well. After that, if you want to create a
    separate user / tablespace / whatever to support another application then
    that is either up to yourself or the other application. I say that because
    many applications that connect to Oracle include scripts which create their
    specific tables, etc.

    In terms of getting Oracle up and running though the installer should guide
    you through that, and can even create a demo user (his name is Scott) with
    a few tables (a Human Resources application, although considerably less
    complex than SAP HR) to play around with.

    Regards,

    Mark.

    "Santosh
    Varma" To: Multiple recipients of list ORACLE-L
    Subject: RE: Installation
    Sent by:
    root_at_fatcity.c
    om

    22/10/2002
    16:48
    Please respond
    to ORACLE-L

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

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Santosh Varma
    INET: vsantosh_at_psi.soft.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).

    <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    Privileged/Confidential information may be contained in this message.
    If you are not the addressee indicated in this message
    (or responsible for delivery of the message to such person),
    you may not copy or deliver this message to anyone.
    In such case, you should destroy this message and kindly notify the sender
    by reply e-mail or by telephone on (61 3) 9612-6999.
    Please advise immediately if you or your employer does not consent to
    Internet e-mail for messages of this kind.
    Opinions, conclusions and other information in this message
    that do not relate to the official business of
    Transurban City Link Ltd
    shall be understood as neither given nor endorsed by it.
    <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Mark Richard
    INET: mrichard_at_transurban.com.au

    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 at Oct 22, 2002 at 7:48 am
    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 datafile '/path/to/datafile_name'
    size;

    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).
  • Santosh Varma at Oct 22, 2002 at 7:53 am
    Thanks richard for the information.
    santosh

    -----Original Message-----
    Richard
    Sent: Tuesday, October 22, 2002 12:48 PM
    To: Multiple recipients of list ORACLE-L

    Santosh,

    Oracle has an installation program which will create the internal tables,
    views, tablespaces, etc required to start Oracle. It will guide you
    through that process fairly well. After that, if you want to create a
    separate user / tablespace / whatever to support another application then
    that is either up to yourself or the other application. I say that because
    many applications that connect to Oracle include scripts which create their
    specific tables, etc.

    In terms of getting Oracle up and running though the installer should guide
    you through that, and can even create a demo user (his name is Scott) with
    a few tables (a Human Resources application, although considerably less
    complex than SAP HR) to play around with.

    Regards,

    Mark.

    "Santosh
    Varma" To: Multiple recipients of list
    ORACLE-L
    Subject: RE: Installation
    Sent by:
    root_at_fatcity.c
    om

    22/10/2002
    16:48
    Please respond
    to ORACLE-L

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

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Santosh Varma
    INET: vsantosh_at_psi.soft.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).

    <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    >>>>
    Privileged/Confidential information may be contained in this message.
    If you are not the addressee indicated in this message
    (or responsible for delivery of the message to such person),
    you may not copy or deliver this message to anyone.
    In such case, you should destroy this message and kindly notify the sender
    by reply e-mail or by telephone on (61 3) 9612-6999.
    Please advise immediately if you or your employer does not consent to
    Internet e-mail for messages of this kind.
    Opinions, conclusions and other information in this message
    that do not relate to the official business of
    Transurban City Link Ltd
    shall be understood as neither given nor endorsed by it.
    <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    >>>>

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Mark Richard
    INET: mrichard_at_transurban.com.au

    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.com
    --
    Author: Santosh Varma
    INET: vsantosh_at_psi.soft.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).
  • Santosh Varma at Oct 22, 2002 at 10:54 am
    Thank you Mark very much for the detailed description

    santosh

    -----Original Message-----
    Bobak
    Sent: Tuesday, October 22, 2002 1:19 PM
    To: Multiple recipients of list ORACLE-L

    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 datafile '/path/to/datafile_name'
    size;

    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/stat
    em4c.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).

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Santosh Varma
    INET: vsantosh_at_psi.soft.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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 21, '02 at 10:38a
activeOct 22, '02 at 10:54a
posts13
users7
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase