Skip to Content
avatar image
Former Member

Tablespace owner name

Hi gurus,

When i am creating Tablespace in oracle10g using brtool ,what name should i provide in option Database owner of tablespace??I loggedon using SAPADM user.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 23, 2008 at 12:54 PM

    Hi,

    Pls go through this link.

    http://help.sap.com/saphelp_erp2004/helpdata/en/99/eaac06eec707428e2b0b9d9d9d647a/content.htm

    The owner it is asking for the objects taht are going to be part of that table space..

    AS per above link it asks only in MCOD.

    Go through that link it may be helpful.

    And in SAP the objects will be owned by the schema ...example:SAPSR3 like this.

    You can get list of these user from this command :

    Select username from dba_users;

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Vani ,

      Could you please specify me the owner in case of dual stack, there are two schemas SAPSR3 for ABAP and SAPSR3DB for java?

      Regards,

      Pavan.

  • Jul 23, 2008 at 12:41 PM

    Hi Nadeem,

    -


    Main options for creation of tablespace in database TDB 1 - Tablespace name (tablespace) ......... [PSAPTEST] 2 - Tablespace contents (contents) ....... [data] 3 - Segment space management (space) ..... [auto] 4 # Database owner of tablespace (owner) . [] 5 # Table data class / tabart (class) .... [] 6 - Data type in tablespace (data) ....... [both] 7 # Joined index/table tablespace (join) . [] 8 ~ Uniform size in MB (uniform) ......... [] Standard keys: c - cont, b - back, s - stop, r - refr, h - help -

    I assume you are talking about this screen are you?

    See the fields with a '#' are locked - you cannot enter anything here.

    That's because a tablespace does not have an owner.

    It is not an object of your database but one of the database management system. It's just storage infrastructure.

    regards,

    Lars

    Add comment
    10|10000 characters needed characters exceeded