Results 1 to 12 of 12
  1. #1
    Join Date
    Jul 2012
    Posts
    7

    Unanswered: Oracle 11g EE on Windows management of Tablespaces vs Users

    How to create/manage multiple table spaces and users from Oracle Database 11g Enterprise Edition 11.2.0.1.0.

    please advice.

    I have installed Oracle 11g EE from below link,

    Oracle Database 11g Release 2 for Microsoft Windows (x64)

    esp :

    Oracle Database 11g Release 2 (11.2.0.1.0) for Microsoft Windows (x64)
    win64_11gR2_database_1of2.zip (1,213,501,989 bytes) (cksum - 3906682109)
    win64_11gR2_database_2of2.zip (1,007,988,954 bytes) (cksum - 1232608515)


    So after downloading, I have installed it. so my question is I couldn't see any admin portal to create/manage tablesspaces and new users and associate some privileges etc.

    How can I do such things, did I do proper installation?

    Kindly advice,

    Raja

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Did you just install the software?
    Did you actually create a new database?

    >How can I do such things,

    issue appropriate SQL to do what you desire.
    Why do you think you need to create any new tablespaces?

    >did I do proper installation?
    I give up.
    Did you?
    We only know what you post here.

    open Command Window & do exactly as shown below

    sqlplus
    / as sysdba
    SELECT * FROM V$VERSION;

    COPY the results from above then PASTE all back here.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    (Database version is specified in the first message, it is Oracle Database 11g Release 2 (11.2.0.1.0) for Microsoft Windows (x64)).

    As of "tablespaces and users" question: I have an impression that you, actually, don't know what to do. Have you used Oracle before? What is your job (DBA? Developer? Other (what)?). Searching for "admin portal"? Huh? How about SQL*Plus? I believe that you should first learn how to properly use Oracle; then, switch to GUI which will make some operations simpler. But, clicking here and clicking there is - in my opinion - wrong path to take.

    Anyway: you create a tablespace using CREATE TABLESPACE command (who'd guess that?). Then, while creating users (using CREATE USER), you have an option to specify tablespace name (default as well as temporary), such as
    Code:
    CREATE USER sidney 
      IDENTIFIED BY out_standing1 
      DEFAULT TABLESPACE example 
      QUOTA 10M ON example 
      TEMPORARY TABLESPACE temp
      etc.
    (example taken from the CREATE TABLE documentation page).

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >(Database version is specified in the first message, it is Oracle Database 11g Release 2 (11.2.0.1.0) for Microsoft Windows (x64)).

    My posted SQL was not about getting the Version specifically, but more about verifying that a functioning database actually existed.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jul 2012
    Posts
    7
    Problem is :
    I am unable to login using Sysdba as I forgot the password. ( I would rather say, its not working. I saved the password for user SYS as SYS, but somehow its not accepting). So I am wondering to reinstall the software. Please advice how can I uninstall ?

    Additionally:
    I have installed and created database aswell.

    I need to two tablespaces because I have a specific software product with two different versions. So I cannot install both products on same tablespace. and hence I wanted to create two tablespaces. Earlier in 10g I remember I have created tablespaces using some admin portal (OEM i guess) which got installed by defalut package.


    Please guide me.

    Thanks

  6. #6
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Uninstall: using OUI (Oracle Universal Installer).

    Two different versions of your software product: are you sure that you should install it into two different tablespaces? Aren't they, actually, different schemas?

    The fact that you "forgot" SYS password: how do you plan to maintain the whole database, all its users etc. if you forget something important like that?

  7. #7
    Join Date
    Jul 2012
    Posts
    7
    Uninstalling is in progress....

    Yes I mean two different tablespaces. As ver A and ver B of my software product contains same table names with different data in it. So please advice after I install Oracle 11g EE, how can I ensure I can create multiple tablespaces and users associated with them.

    Its painful really to forget. after I uninstall I will install again and I will be keen this time.

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    multiple schemas/users can share the same tablespace without any problems.

    creating new or separate tablespaces add nothing of any value.
    It is like giving chicken soup to a dead man.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    So it is about different schemas, not tablespaces, after all.

  10. #10
    Join Date
    Jul 2012
    Posts
    7
    Please advice how can I create multiple tablespaces A and B and I can create multiple users U1 and U2 to access those tablespaces. Im freshly installing oracle 11g EE now.

    Thanks

  11. #11
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  12. #12
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Quote Originally Posted by guru2012 View Post
    Please advice how can I create multiple tablespaces A and B and I can create multiple users U1 and U2 to access those tablespaces. Im freshly installing oracle 11g EE now.

    Thanks
    Didn't you read a message #3?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •