PDA

View Full Version : ORA-01654: unable to extend index in tablespace SYSTEM


negisx
Dec 9, 2006, 06:46 AM
Hi,

Is there any method to check which tablespace we are using at present?
I am slightly bad at Database Administration and don't have much idea.
Actually, I was creating a view in oracle database in one of the schemas and I got this ORA 01654 error. Now, I don't know how to check whether I am creating objects in SYSTEM tablespace.

Please assist..
Thanks and Best Regards,
Kuku