Search results for query: *

We are using Crystal Reports Developer is version 14.0.4.738 RTM also known as 2011 to develop our reports. We are writing reports against an Oracle 11gR2 database. Our DBA has limited the "sessions per user" to 5 sessions. Problem is, the report I'm working on is hanging and my DBA has...

We are converting some scripts from POSIX to BASH and have bumped into the piped variable scope issue when using a loop. I've read other posts and sites and have realized that I need to do a redirection in order to pass the variable into the loop and come out with the value. Here's the part of...

I'm reading data in from an external table, but the negative numbers are rounding. I don't want them to. So, I set up a simple table and started inserting my values to see if I could understand how and why the numbers are not inserting the way I want them to. Here simply is my 2 column table -...

I am trying to set up connect through a proxy user and only permit the activation of specific roles. I have the following: ALTER USER "Jane.-.Doe" GRANT CONNECT THROUGH XXX_PROXY WITH ROLE XXX_ROLE, SAR_XXX_ROLE; The problem, I suspect, is that SAR_XXX_ROLE is a secure application role because...

Our application is currently setting roles at login time via application code. The roles are identified by a password and we would like to move to a secure application role to enable some specific checks before allowing the role to be set. Ideally, we would like to get the code out of our Power...

We have been tracing sessions to try to drill down to the cause of sluggish insert transactions. We performed a process to insert 600+K transactions logged into the application as the schema owner. Once completed, we performed the same insert test logged into the application via the use of a...

I had been getting a message that I was using the old version of the plan_table when using dbms_xplan package. I dropped the old plan tables (sys.plan_table$, system.plan_table, schema_owner.plan_table). I then created the new plan table sys.plan_table$ using the 10g provided script catplan.sql...

Hi, I have a tab delimited text file with just two columns. I'm looking for help with the definition because it seems to be limited me to CHAR(255) and rejects longer records. I can't find any documentation that states a limitation. Here's my current table definition: CREATE TABLE TMP_MY_XTBL (...

I have a SQL query that I believe is causing an implicit date conversion in my where clause. The query is: select to_char(min(begin_date),'yyyy-MM-dd') from pay_table where TO_TIMESTAMP ('2008-07-01', 'YYYY-MM-DD HH24:MI:SS.FF') <= pay_date and TO_TIMESTAMP ('2009-6-30', 'YYYY-MM-DD...

I have a requirement to load data from an external source, via a third party, into our Oracle database. The file includes date columns in a 12 byte format that was extracted from an Ingres database (of which I have little information). I am told that the 12 byte date format is the Ingres date...

I am setting up a new database to use RMAN. While configuring RMAN, I mistyped. I have cleared all configuration settings back to default, but cannot clear or reset a channel device type. The current setting that is NOT correct, using show all, is: CONFIGURE CHANNEL DEVICE TYPE 'DISK' FORMAT...

Please redirect me if this sounds more like a question for OS forum... We have an OLD application using some libraries that need to be registered on the client - the following 3 libraries oip9.dll, oip9.tlb, and oraansi.dll are what we used with the 9i client. We have recently upgraded to...

I'm trying to size my UNDO tablespace for automatic undo management. The formula for the calculation calls for the number of undo data blocks generated per second. The database can be queried for this using the v$undostat view. Rows are supposed to be written to this view for each 10 minute...

We have just converted an Oracle database from 9i to 10g. We have a number of procedures that declare parameters using %TYPE and make variable declarations using %TYPE or %ROWTYPE. For example: PROCEDURE create_cl_search_query_proc (ps_lst_nme IN resource.lst_nme%TYPE) IS S_search_data...

I have an Oracle data file name with a carriage return. I need to copy the file to a "correct" name (no carriage return) and then remove the "incorrect" file. Can anyone help me with how to issue a cp and rm command with the carriage return in it to avoid the "not found" message?

Need to mirror a directory to a remote server... Servers are HP-UX PA-RISC (64-bit). We are currently using a script written in Perl to mirror a local directory to a remote server. This script is run every 5 minutes. The problem is that when there are numerous files in the directory, sometimes...

I have been working on correcting (and understanding) a logon trigger that sets trace on... In short, the trigger does the following: 1) I set a string that includes the users name to append to the trace file: s_trace_file_name := LOWER(SYS_CONTEXT('userenv', 'session_user')); 2) I alter the...

We are working on upgrading our databases to 10g. We have several 9i instances running on an HP-UX server and have recently upgraded one of the instances to 10g. In the process we upgraded the listener.ora to 10g. We are finding that tnslsnr is constantly showing in our top list of processes...

My create database failed with the following error: ORA-00443: background process "CJQ0" did not start. Searches on the error come up with the cause being "The specified process did not start." The solution: "Ensure that the executable image is in the correct place with the correct protections...

I am using a posix shell script to perform a nightly export of a specific schema in my database... I'm checking the exit status of the exp command, but am finding that I really want my messaging to indicate when the exp has completed successfully with warnings. The problem is that the numeric...