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.
How to store a bitmap or jpeg file on oracle database?which datatype is used and what is the retrival method ?
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
Latest Answer : Hi Friend,Here is simple defination initSID.ora will tell you SID is the database name where you are going to creating a new database.when you create database it'll take you as pfile and spfile is the system parameter file which you can convert if you ...
Hai i have installed oracle 10g on my system.and it shows that Pro C has also been installed but i am not getting any access to PRO C i.e i am not getting PRO *C UI(user interface) .how to access or start PRO C UI. please help me out.also i installed Oracle HTTP server and oracle companion products on my system but but i am unable access HTML DB. on what port numnber it will be accessible .also need help how to access text file in oracle,pl/sqlplease helpits urgent.prabhash
I have win xp having oracle 9.2 and on same system win 2k having oracle 9.0. can I share data , redolog and control file . if yes then how? please give example. as per me its just not possible.
Hi All, How do i run the otrcsvr.sql file in Oracle9i, it is suppose to be available in @$ORACLE_HOME/rdbms/admin; But its is not present in that folder. Can i use another script on Oracle 9i to achieve the same ?Regards,Ashish
Is there any way to import the excel data in to oracle database without using the SQL loader, please let me know.
Latest Answer : Well,if you have less data ,you can just copy the data; for exampleselect * from table for update then open the lock, then copy the data from excel to the database; ...
How to determine whether particular parameter of parameter file is static or dynamic?
