 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. Latest Answer : Select * from dba_objects where owner = 'GL' and object_type = 'TABLE'Change GL to AP and AR for respective table info. ... Read Answers (1) | Asked by : mahendra Latest Answer : For time being type below command at sql promptSQL>define_editor=viYou can add export EDITOR=vi in .profile and logou/login for permament changeHope this will solve it ... Latest Answer : You can get the current value of the Sequence by querying DBA_SEQUENCESColumn name is Last_numberThanksHari Kiran P. ... Read Answers (3) | Asked by : ram Latest Answer : Co-related sub-query:- The main differencre between subquery and co-related subquery is that in subquery child query is executed first n then parent,but in co-related subquery main query is executed first(even though parenthesis are present) and then ... Hi all, I recently installed Oracle 9i database and Oracle forms6i in my system. I couldn't access database through forms.If i try to connect, "ORA 12203: TNS: unable to connect destination" error is occured.Can anybody resolve this problem? How do I find out the time taken by oracle to execute the sql statement or a procedure? Is it possible by firing a select? 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 What is difference between data and informationrelated to ADBMS(advanced database management system) What is difference between data and informationrelated to ADBMS(advanced database management system) ! plz explain in detail ! View Question | Asked by : viral
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
