Urgent!!unable to extend table space!!

[Former Member]

Hi Shaji

I am basically a BI Consultant..I am facing the same problem..I dont have idea abt all these Database Settings..

Can give me a step by step solution to resolve this issue..???

I saw your post on ORA-1653...even i face the same issue..

when I store in temporary database...

"DBSIF_SQL_ERROR..........."if I do it in Main memory

I get it as "NO MORE SPACE AVAILABLE"...

pls give where I can solve on my own,,,or only BASIS guy can do...

BI Learner.

[markus_doehr2]

The tablespace mentioned is full - you need to start "brtools" on operating system and add a datafile so the database can store the data.

Markus

[Former Member]

hi Markus

thanks for ur reply.

Can you tell me about the "BRTOOLS"??

Regards

Raji.

[Former Member]

Hi,

check following sap notes

Note 651812 - FAQ: BR*TOOLS and SAPDBA

Note 12741 - Current versions of BR*Tools and SAPDBA

regards,

kaushal

[Former Member]

hi Kaushal,

Do u have any idea about table space for APD??

Where it stores ??how to find the space occupied by it??

[andreas_herzog]

plz check either transaction DB02 or DBACOCKPIT in order to see the filling grade of each tablespace...oracle needs "containers" (called tablespaces) to store data in it...these tablespaces comprise of one or more data files which usually are located in the file system (at operating system level)...if a tablespace becomes full one has to add another data file using either BRTOOLS or sqlplus...

check out sap.help.com:

[Extending a Tablespace using BR*Tools|http://help.sap.com/saphelp_nw70/helpdata/en/1b/d20f6fe45a9e43b1856ea1b52c9612/content.htm]

GreetZ, AH