Search results for query: *

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

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...

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

I would like to grant the priviledge to a user to be able to change other user passwords (hence 'alter user' priviledge) ,however, I do not want them to be able to change the password for critical accounts like 'sys'/'system' etc. Anyway to do this? Adrian Certified DBA/Developer

I need to connect up to a client's server and use the Oracle tools to configure, create databases etc. I really like using the database configuration assistant (DBCA) but I need to have a graphical interface; hence, my question on x-windows. I am interested in finding out which x-windows...

I am having some problem trying to save a value in a calculated field to the database. Here is the information... Database: Field_A number Field_B number Field_C number Form: I have placed Field_A, Field_B, Field_C onto the form. I then opened the properties of Field_C and typed the...

Hi there, I am an Oracle DBA/Developer and I am curious how one becomes an Application DBA? I do not see any exams for this. Does this just mean that the DBA has experience with the Oracle ERP software? Just curious. Adrian DBA/Developer

Does anyone have any advice on how to learn 11i? I am a DBA/Developer that has been asked to delve into this area. I believe it will become a growing area of concentration for my work. The problem is that I need to learn it prior to working with a customer. I have the 11i cd's (all 100 of...

I have written a function which outputs a CLOB. I now want to add an exception section so that the CLOB output will be "More than one note" if the error is too_many_rows. The output populates a field in a report. If there is more than one row I need the field in the report to inform...

Hi there fellow Oraclies, I am running STATSPACK and after three days of snaps I would like to execute the sql script for report generation. My understanding is that there should only be 3 prompts: - file name - begin snap - end snap I am getting prompts for every paramter it seems (i.e...

Hi there fellow Oraclies, I am running STATSPACK and after three days of snaps I would like to execute the sql script for report generation. My understanding is that there should only be 3 prompts: - file name - begin snap - end snap I am getting prompts for every paramter it seems (i.e...

Hi there, I am a little confused about this error message. When I am logged in as "sys" I can run the query without a problem and view the results, but when I log in as a user I receive this error. If the error is indicating that the datatype is not declared properly in the code (as...

I need to clone a database that resides on a UNIX server onto my pc which is running XP. I am not sure if there are any hurdles in doing so. Can this be done and is there anything I need to do above the usual db cloning steps? My thanks in advance. Adrian

After completing all formatting I configured Tools|Start up and I disabled most of the menu's. Now when I open the database/application I only get File, Window and Help displaying on the top menu. HELP! How can I get the other menus showing up again. "Tools" on the menu which...

I am a Oracle Developer that has been asked to take on the DBA role in 2 months time. I am very familiar with the OEM but I thought I would ask the experienced DBA's on here if there is 3rd party software that is favored to troubleshoot the DB rather than using the Oracle tools to make the job...