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

Thank you! I had read various sections of documentation and blogs, but could not get the redirect syntax right! I've done some more reading about here-documents and your solution makes more "readable" sense to me. It's important to me to know "why" the code works, not just that it does. I have...

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

Could you clarify - are you trying to link a third table that contains public holiday records? It looks like you have the public holiday dates in a column of the same table as one of the input dates (U3L.DTK.DATE3)? What are the columns in U3L.DTK and U3L.DPL? (Maybe include a sampling of 3 or...

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

Thank you for the update! I had originally searched everything I could think of in Metalink. If you happen to bump into the Note or I do, we should post the reference here just for continuity. Nonetheless, I really appreciated you fast-tracking the solution and getting me past the issue!

Thank you! It worked perfectly to resolve the issue. Seems like a "no brainer", although, I was hoping for something official from Metalink/Oracle before I made this a common practice. I can't find anything from Oracle to indicate this is a known bug - seems like there should be something! But...

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

1000 purple stars for you if I could! Thanks, that did it. I haven't seen it anywhere! I greatly appreciate your help!

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

Thanks for the additional insight. My original question probably didn't make it clear, but it's the implicit conversion of pay_date and end_date (to_timestamp(to_char(column)) that I am trying to handle in a function-based index to avoid the overhead at execution time. In a perfect world, the...

This did help. And, it really helped with giving that "second opinion" that to_timestamp could not be used to create the index (at least not without some tinkering). What I would like to find is some documentation providing more of a list of functions that cannot be used. Instead, I find only a...

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

Many, many thanks for breaking out the 12 bytes for me!!! I can now easily calculate the year, month, and day and it's working great. Times are all zero in my file, so I can't really verify anything there. My first 2 bytes apparently have newer values? I am getting 7424, which I haven't been...

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 was successful. Here's what I did and what the problem was: (Verify bad channel setting) SYSTEM>select * from v$rman_configuration; CONF# NAME VALUE ----- -------- --------------------------- 5 CHANNEL DEVICE TYPE 'DICKSK' FORMAT '/vg06lvol1/oradata/brdt/rman/bkp_'...

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