 Related Questions I have got the following error when importing few of my package bodies and triggers. ORA-01653: unable to extend table SYS.IDL_UB1$ by 13 in tablespace SYSTEM The tablespace SYSTEM had enough space at the time of import. Later when I tried to create theses objects seperately through a script, they were successfully created. It is important to note that not all package bodies and triggers failed. If you have any idea regarding this error, please let me know the problem and solution, if possible. When i create any table in my schema an error occurs : ORA-01658: unable to create INITIAL extent for segment in tablespace OWAPUBHow to overcome of it? Read Answers (2) | Asked by : Kirti Kumar Gupta View Question | Asked by : kaushal jha Tags : Backup Can any one tell me how the get the datafile when my controlfile is lost and i have created a new controlfile. and the information about the datafile is present in the previous controlfile which is corrupt and deleted. and there is no backup of the datafile is present Tags : Backup We are facing one problem one of session is aborting after updating 2~3 lakhs records which is taking around 1hr and still there are 2lakhs to update. we are running again this starts updating from scratch of the reocrd.If i use enable recovery option will the record updates from the 200001 or from 1st reocrd and will i save the time by using this option? Read Answers (1) | Asked by : Rajkumar bachu Hi All, Getting the following error in Oracle9i on AIX, unique index ORA-01652: unable to extend temp segment by 128 in tablespace USERS; though the USER tablespace is of 10gb.Could anyone provide a solution.Regards,Ashish Thomas Latest Answer : It is not necessary if your database is running in archivelog mode i.e. automatic archiving is enabled. ... Read Answers (1) | Asked by : sitanshu Tags : Backup How to solve the database block corruption error? even index also validated and recreated and don't have any backup. Latest Answer : By using DBMS_REPAIR ... How we identify instance name, free space, used space in database & datafile that makes up the system tablespace? Latest Answer : To check for instance name:-SQL> show parameter instance_nameTo check for free space in tablespace:-SQL> desc dba_free_spaceTo check datafile size:-SQL> desc v$datafile ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
