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 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?
Hi, suppose i have 2 managers M1 & M2. S1 & S2 are Sales reps under M1. S3 & S4 are Sales reps under M2. Suppose S1 (whose manager is M1) creates 2 records. S2 will be able to see them ?.Now, if i change the parent position of S1 (i.e., if now, S1 is placed under M2 instead of M1), and responsibility remaining the same as earlier (Sales rep resp), will the Manager M1 be still able to see the records created by S1 ? Please clarify this. Thanks
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?
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
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 ...
I want to tune the sql query written on two field change peoplecode please help me to tune the query as it is very urgent i am pasting the query isAMT1 = 0;AMT2 = 0;AMT3 = 0;AMT4 = 0;If All(DATE_FROM) Then &FROM = " and asof_dt >= %DateIn(:ml_gul_40a_wrk.date_from)";End-If;If All(DATE_TO) Then &TO = " and asof_dt
What is difference between data and informationrelated to ADBMS(advanced database management system) ! plz explain in detail !
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.
