 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. I am creating one table in oracle. in database it is allocated some memory for that table. how can i know how much memory that table is holding in that database? Latest Answer : Dual is a system defined table having one rows and one column. A person who has informed that it has virtual
existence is not proper. It has physical existence.Ex:SQL> select * from dual;D-XMeans a table having single row and columns.Regards,Deepak ... How to delete duplicate values from tableFor Ex: A table contains 200 rows in that 100 rows are duplicate values, how to delete those 100 rows? Hi,I have scenario where I need to upload data from XML file into a table. XML file is a predifined format. How can I achieve this, Is there any built in package similar to SQL loader to extract required field values and upload them into table.Pls suggestThanks Read Answers (2) | Asked by : vishnu View Question | Asked by : Vikram Write down a query for inserting 'n' rows into a table, prompting for the values each time a record is inserted 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? 1. can we use DML operations on Dual Table?2. What is difference between View and materialisedView?3. New features in Oracle9i SQL? Read Answers (3) | Asked by : vijaya 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
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
