Search results for query: *

The command line expdp allows for not exporting grants (as did exp). However, I cannot get that feature to work with the APIs. Has anyone done this with the API?

Executing the equivalent of SELECT DBMS_SQLTUNE.report_tuning_task('SQL TASK') FROM dual It produces the general information section; the SQL ID; the actual statement and then generates an Error Statement. ORA-00942 Table or View does not exist. I trapped for the error and the trace...

I several did timings of these two options for cursors and found INSENSITIVE consistently faster, which surprised me. Does anyone have any experience with the INSENSITIVE option and it ability to scale. It appears to have a higher usage of TEMPDB space which is a concern in our environment.

We have a production system where the CPU was pegged at 100%. When I analyzed the saved data (sysprocess and profiler results) it appeared that at the start of the high CPU usage there were quite a few deadlocked processes (6+). But why would this cause the high CPU usage? It would seem that...

We have two processes going, one polls sysprocesses and the other is sysprofiler. Both have measurements for CPU usage in milliseconds. According to documentation CPU usage on sysprocesses is a cummulative total. However, we are seeing CPU milliseconds in the sysprocesses for a SPID that are...

We have a need to, with a query, to return the number of rows into a report that represent the number of years between two dates. So, we have a start date of 1/1/1999 to 1/1/2004 and we would need a row for 1/1/2000 and 1/1/2001 and 1/1/2002 and 1/1/2004. Anyone know how to do this without an...

DATEADD(MONTH,1,'6/30/99') returns 7/30/99 I want it to return 7/31/99. If the date is 6/15/99 I would want it to return 7/15/99 (which it does). Please, any ideas of what to do here?

We were on a tight deadline, the customer gave me MSSQL 2000 to develop on. Now they say they need all of the procedures / functions etc in MSSQL 7. It has been a while since I developed in 7.0 BUT I am not seeing the capability for creating functions. Is that really true? MSSQL 7.0 did not...

Basically we have some stored procedures being called from C++ code. The procedures gather data and populate tables against which a report will be run. But the C code returns immediately without waiting for the results. Any ideas? Thanks.

I am doing a simple function with a cursor. I declare the cursor, open the cursor, fetch the cursor. And it compiles fine. I add an if statement right after the fetch and the compiler says error at THEN. I tried different ifs, and different statements within the if. It does not like anything. I...

I need to write some stored procedures against this version of SQL Anywhere. It comes bundled with Sybase Central which has ISQL as an interface (if you can call it that). It is no way of trying to develop complex stored procedures. I tried a couple of ODBC based interfaces (including mySQL and...

Sure, I know we can encrypt by saying CREATE PROCEDURE with ENCRYPTION. But what about the file we load from at a customer site. What good is the encrypted procedure if the file we use to create the procedure is not encrypted. Is there an easy way to do this? I tried encrypting and then...

I wrote a series of stored procedures that create tables to be reported against. We have used Crystal reports as an interface. But I am not happy with the way the user has to input parameters and the limitations. Was thinking of doing a VB interface to Crystal. Anyone has some better ideas? I...

All of the following works without a problem on 8i (8.1.7). However, I need it to work in our 8.0.5 database. Function Prototype in package header: FUNCTION Return_Factor ( Date_One DATE, Date_Two DATE, Date_Compare DATE, Compare_type VARCHAR2 ) RETURN...

I created a unique index to get a query to run faster. The explain plan is fine in most databases after the index is created. Query goes from two minutes to 1 second. However, the database I really need it to work in will not use the index without the /*+ rule */ hint in the Select. We are...

I am getting a RUNTIME error when using objects "Missing right parenthesis". We have run this in a different version installation of Oracle (8i) without a problem. But the newly installed oracle8 enterprise edition is giving us a problem. Oracle support closed the support track saying...