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?
I am having WHEN-NEW-ITEM-INSTANCE trigger at Form, Block, Item level what is the sequence of execution? And if I want to change there sequence how I have to change?
Can a Revoke or alter user statement be executed on a Session to modify a user's role (set as default) or revoke a role based on whether the uesr logged into a defined list of valid applications versus SQL Plus? I want to set one role if the user connects via an appropriate app and set a readonly type role if the user connects with something else. This is needed to resolve an audit issue.
How to store a bitmap or jpeg file on oracle database?which datatype is used and what is the retrival method ?
Latest Answer : Hi,The databse domain are the differenet types of database. Database domain can be Oracle, MS SQL Server, Sybase etc. It's depend on user on which database domain he can work better.Suppose if we select oracle there different domains are: Oracle ...
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 can I upgrade Oracle Database and Client 9.2.0.6 to 9.2.0.7? I downloaded the 9.2.0.7 patch, but when I login to SQL*Plus, it still shows both server and client to be 9.2.0.6.Where do I get the upgrade software?And how do I upgrade?
Latest Answer : Hi,If a Form Item's property needs to be changed, then it should be done from a form trigger and not a database trigger. You can use Visual Attributes or Property Classes to achieve this or a form trigger. Depending on your criteria, you can use form ...
Hi, We are on Oracle Apps 11.5.8Database 9.2.0.6 We want Report outputs in excel. Is there anyway we can get the same. Sajani Pillai
