gkaindia.com

Home > > Tablespace 0% free - Oracle / NT

Tablespace 0% free - Oracle / NT

Advertisement
My client copies are failing due to lack of tablespace room.
IN DB02 I have the following info:
Total number                        6                
Total size/kb             152.750.080                
Total free/kb               2.607.104      1 %       
Minimum free/kb                16.384                
Max. autoextensible/kb    563,200,000                
ON Freespace statistics I have:
Tablespace            Freespace          
Maximum/kb      Maximum/kb    Total/kb   
SYSTEM               260032        260928
PSAPUNDO                  0             0
PSAPTEMP                  0             0
PSAPIDS               19392         20544
PSAPIDS640            12224         97408
PSAPIDSUSR            16384         16384
ON Critical Tables/IND...
Tablespace     Freespace     /kb          Next extent/k
     Maximum     Total          
PSAPUNDO          0     0     8.192
PSAPUNDO          0     0     65.536
PSAPUNDO          0     0     8.192
PSAPUNDO          0     0     8.192
PSAPUNDO          0     0     65.536
PSAPUNDO          0     0     65.536
PSAPUNDO          0     0     8.192
PSAPUNDO          0     0     8.192
PSAPUNDO          0     0     65.536
PSAPUNDO          0     0     8.192
I've tried to run DBA planning calendar the actions below:
NEXT Extent. The following command was issued:
BRCONNECT -u / -c -f next -t ALL,PSAPIDS,PSAPIDS640,PSAPIDSUSR,PSAPTEMP,PSAPUNDO  
REsult:
BR0903I Number of tables in locally managed tablespaces: 47323         
BR0904I Number of indexes in locally managed tablespaces: 57328        
BR0901I Number of tables to check (and adapt if needed) next extent: 0 
BR0902I Number of indexes to check (and adapt if needed) next extent: 0
BR0905W No tables/indexes found to check and adapt next extent         
If I try on CMD  BRCONNECT -f NEXT I get the error
ORA-01017: Invalid user/password; logon denied.
How Can I extend the tablespaces? I need to finish my client copy.
Thanks a lot.
Message was edited by: Leonardo De Araujo
Advertisement
Hi Leonardo,
It's a while since I've worked on an Oracle based SAP system but this is what I remember.
Do you know exactly which tablespace(s) are filling during the client copy ? You can probably see them on the SAP system log. I guess it will be one of BTABD/I, STABD/I, POOLD/I or CLUD/I.
Once you've identified the tablespace(s) that have filled, you can add datafiles to the affected tablespace(s) using sapdba.
The following SAP Help Portal URL may also be of use:
http://help.sap.com/saphelp_47x200/helpdata/en/42/51b3144a1211d182b80000e829fbfe/frameset.htm
Regards,
Gary
Read the other 3 answers
Dear All, I'm planning of doing a carrying out a Tablespace Reorganisation of the schema tablespace on the production server. I need your views regarding the process to be taken and tuning that is required before carrying out such an activity. For yo
Hi Do I need same oracle versions if I want to transport tablespaces ? i.e Can I transport tablespaces from oracle9i to oracle 11g ? or from oracle 10g to oracle 11g ? I read the documents however Im still confused.Thanks, I have read the document an
The tablespace file of an database schema in oracle 10 is twice the size of the same database schema in oracle 9( 16.4 GB versus 8.11GB ) At first I thought it was due to the charachtersets used, but these are in both the versions the same, in oracle
Hi team, I have 5 oracle databases and they all are on different machines. i want to fetch data(tablespace data) from db to excel. here is my macro code Sub tbs_STD() Dim Conn As New ADODB.Connection Dim RS As New ADODB.Recordset Dim Cmd As New ADODB
Hi Guys, Not sure if this has been asked before. I have created a couple of table spaces in my database and one of these tables is holding all my data. For that table space, I have added at least 8 data files so far and it seems that Oracle uses the
Hi all, We are using oracle 9.2.0.7 version in our production.In that one tablespace is having 160GB but objects size is 60Gb,am unable to get back the remaining space.So we are planning for either creating new tablespace and moving all the objects t
Hi, I would like to know whether system tablespace in oracle 9i by default is locally managed or dictionary managedHi, I would like to know whether system tablespace in oracle 9i by default is locally managed or dictionary managed SYSTEM tablespace i
Hola, tengo un crecimiento excesivo del tablespace TEMP y no encuentro la causa, Consulte la v$sort_usage pero no muestra nada. Como puedo solucionarlo ? Gracias JorgeHi, Your question covers a wide base of knowledge, which I'd really advise you get
I have used Oracle 9i (9.2) database in my P.C. Today my database(ORCL) not open due to corruption of EXAMPLE01.dbf datafile. Now I want to drop the tablespace EXAMPLE associated with EXAMPLE01.dbf file. My database now in mount stage, so i can not d
Hi, Anyone still using Oracle 7 ? I would like to know the sql to check the temporary tablespace and its datafile size. Thank, Regards, Eye Geehttp://www.oracle.com/technetwork/documentation/oracle7-091910.htmlRead other 2 answers
I am migrating from MS SQLServer 6.5 to Oracle 9.0.1.2. Whenever I run the OMWB process to load the table data into the destination Oracle database, OMWB creates a tablespace named after my SQLServer database name. This is fine; however, the datafile
Oracle (10.2-asm) RHEL 4.2 total table =1000 total partitions=1000 total index = 1000 =============== Currently I have only 10 tablespace for above objects. What is the benifit of having more tablespace? I am working on a new tablespace architecture.
Hi Guys, it is may be simple but not getting through.. i am using below query to find in db that bytes used and bytes assigned at tablespace leve but not getting correct results. i have tablesspaces whos size is intially 100mb for example and autoext
I am very new to Oracle 10g Express Edition. We have a server running Oracle Enterprise Edition and we have been creating a transportable tablespace to be imported into a few servers. This works fine for us. I would like to find out if I can import t
Hello Our environment: Oracle 10.2.0.3 3-node RAC, ASM, Linux x86-64 We are using EM Grid Control as a monitoring tool for RAC databases. We have "tablespace SPACE USED (%)" metric configured for all RAC databases. For some reason this metric do
I have a nightly process that uses expdp/impdp with Transportable Tablespace option to copy a full schema from one database to another. This process was initially done with just expdp/impdp, however the creation of the indexes started to slow down th
hi, i am working in oracle 8.1.7.4.0.i am creating a temporary tablespace. After creating the temp tablespace i am going to assign it as default temporary tablespace. alter database default temporary tablespace <tbs-name>; but its showing error...as
Dear Experts, Please Tell me What is the use of SYSAUX Tablespace in Oracle 10G Because during Web Load Testing It is going to increase countinuosly.Although i am not using this with any tables. How Can I find out the what is gong on in this. Can I R
Hi All, We have got two user accounts with two sperate tablespaces respectively in Oracle 10GR2 single instance. Now we would like to clone user A with tablespace A to user B with tablespace B in the same Database instance. Will much appreciate any h