Recent content by ajhull

I am aware of FGA, but FGA will not tell me what the select statement was. My customer needs to know what records in the table were accessed and by whom. Triggers won't work because those are only for update, delete and update. I was thinking that the solution would be to link...

I apologize in advance for asking a non-technical question in this forum but I am not sure where else to ask it. I would like to become certified in a programming language and would like to make sure it is the language that is going to give me the biggest payback from my investment of time...

I understand that the resolution for this problem is to increase the shared pool. However, I am confused why I receive this message on the second database when no activity has been done on it (no users other than myself logged in and I am not doing any parsing etc.) Could the cause of this be...

Hi all, I have all the cd's for Oracle Financials (all 100 of them!). I am wondering if anyone in here knows approximately how many Mb or Gb are needed to be able to implemeent a simple GL and Payables so I can have a system to learn from. Adrian Certified DBA/Developer

That answered my question Mufasa. Thanks very much...I really appreciate it when people like you contribute your knowledge. All the best. Adrian Adrian Certified DBA/Developer

You were correct Mufasa. Here's the scoop... I need to be able to do snapshots of the database and be able to restore the database to the snapshot timestamp. I have not had to provide this in the past but it is now being requested by some instructors that wish to be able to rollback the...

I performed a test: 1) Created a user named "STEVE" at 10am 2) Shutdown the database 3) STARTUP MOUNT 4) Performed an incomplete time-based recovery by issuing command "recover database until time '2004-10-14:09:00:00'" 5) Issued cammand "ALTER DATABASE OPEN RESET LOGS;" I then queried the...

Yes. A point in time restore. I am assuming that I would not have to backup the database to do this and I would just rollback to a specific timestamp. Ah...the teacher of the class...not my teacher. I have been out of school for quite some time now. The teacher (instructor) is just a...

One thing I have never had to do is take a snapshot of the database and roll the database back to the snapshot state after a day of activity. I have been asked to do this. There is a testing database and the teacher would like to roll the database back to a point in time apon request. How do...

I have a customer that requires auditing of unsuccessful attempts to login. Can this be done? If it can, what information is captured? Oracle 8.1.7 Adrian Certified DBA/Developer

Does anyone know of any issues with performing an export from an 8i database and importing to a 9i database? I am curious if anyone in this forum has done this, and if so, possible issues. Thanks in advance. Adrian Certified DBA/Developer

Thanks. I am using a trial version of x-manager right now...works well. I chagned the DISPLAY parameter on the unix server as suggested. Thanks Adrian Certified DBA/Developer

Perhaps I am confused now.... I thought... 1) scott(dba) compiles and has the 'alter user' priv 2) grants execute priv on procedure to yada 3) yada does not have 'alter user' priv 4) yada can still execute the procedure successfully If this is not the case then why would I even bother...

Once again. thanks. :) Adrian Certified DBA/Developer

Mufasa and Karluk, Many thanks. And thank you for the example - I learnt something there. I will deploy into the test database. Final question: I am guessing that the person that initially compiles this procedure would have to have the 'alter user' priviledge for it to compile correctly...