I am reorganising an index online the details are as follows.
Tablespace to which the index belongs : PSAPBTABI
Index name :VBOX____0.( size of this index is 70 GB)
PSAPTEMP is 100 GB and max extends is UNLIMITED
PSAPBTABI is 500gb of which 200 is free and max extends is UNLIMITED.
I have droped the index sucessfully.
But When I tried to create the index I am facing the following problem
ERROR at line 2:
ORA-01652: unable to extend temp segment by 286560 in tablespace
And the script I used to create the index is as follows.
CREATE UNIQUE INDEX "SAPR3"."VBOX______0"
PCTFREE 10 INITRANS 2
STORAGE (INITIAL 1018880K NEXT 1018880K
/* USED SPACE 70843568K */ MINEXTENTS 1
Kidly provide me solution if you have for this.
Thanks in advance.
Chandra Sekhar Reddy.
- Extending Tablespace using BRTOOLS
- How to Find a SQL_ID and Top SQL query Using Temp Tablespace Which Causing Temp Tablespace to be Full?
- Why By Default Temp in Nologging?
- Can I delete temp tablespace at OS level by giving -rf temp01.dbf?
- SAP Query relating to layout variants for temp query Reports
- What different things get stored in system,sysaux ,temp and users tablespace?
- Can We Extend tablespace when backup is Running?
- Trying to find who is using temporary tablespace
- By Mistake System Admin deleted undo tablespace.
- EXTENDED WITH HOLDING TAX
- Extended Withholding Tax Configuration Document
- Proposal to ementor abap basis
- Basis (BC)
- Golive Pre and Post BASIS Activities Major Activities
- SAP Basis and Sucurity Administration
- SAP FICO PDF Book By Meghanath Reddy.A
- SAP Basis Installation on Windows NT: Oracle Database
- ALV (ABAP LIST VIEWER) Step By Step Explanation
- SAP R/3 BASIS - An Introduction
Opening for Sr. SAP Basis Consultant @ Bangalore (Immediate
Exp :6 - 15 years | City : Bangalore
SAP with Portuguese & English Langauge Support | 3 - 6 Years
Exp :3 - 6 years | City : Hyderabad
SAP Basis Consultant | 3 - 8 yrs | Mumbai | Dynamix Balwa Gr
Exp :3 - 8 years | City : Mumbai
SAP Basis Consultant | 6 - 11 yrs | Pune | Xoriant Solutions
Exp :6 - 11 years | City : Pune
SAP Basis Consultant | 3 - 5 Years | Pune | TATA TECHNOLOGIE
Exp :3 - 5 years | City : Pune
SAP FICO / SAP HCM/ SAP SD | 5 - 7 Years | Chennai | Hinduja
Exp :5 - 7 years | City : Chennai
SAP Basis | 2 - 7 yrs | Coimbatore , Chennai | Trigent Softw
Exp :2 - 7 years | City : Chennai
SAP Development Basis & Solution Manager | 12 - 14 Years | B
Exp :12 - 14 years | City : Bangalore
SAP Basis HANA & OSDB Migration Engineer | 5 - 10 yrs | Bang
Exp :5 - 10 years | City : Bangalore
SAP Basis Sr. Consultant | 6 - 9 yrs | Hyderabad / Secundera
Exp :6 - 9 years | City : Hyderabad