Tablespace owner name

[Former Member]

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.

[former_member1351727 · Accepted solution]

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.

[Former Member · Accepted solution]

Thanks a log guys for your inputs.@Vani ,the link which you gave it helped me a lot to resolve a problem.

Thanks.

[pawan_amarnani · Accepted solution]

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.

[lbreddemann]

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

[Former Member]

Hi lars,

Yes u r right, i am talking about the same screen.But instead of # its showing ? and i cannot proceed ahead.

Theres an error owner not found in database.

Thanks.

[lbreddemann]

Ok, please post the whole logfile.

kr

Lars