Helpforce provides free 24/7 online technical support

Hi! The Query SELECT * FROM T_Test WHERE Start > '1.1.2002'is running with the correct results.
Using a date with time like SELECT * FROM T_Test WHERE Start > '1.1.2002 1:00:01'doesnt work.
My problem is that i have to avoid any function like to_date etc.
Thanks,Ralf

I want to produce a report. Here's a sample table I want to report on: server_name severity log_only notification_only------------ -------- -------- ----------------serverA critical 0 0serverA critical 1 0serverA major 1 1serverB major 0 0 The last two columns can only be a zero or one.
I want a report written in SQL that produces something like: server_name no of messages log_only notification_only----.... read more

My opinion follows: In an attempt to screw anyone and now its DBA base, Oracle is doing yetanother thing ... Oracle on Demand .. also know as the end of thein-house DBA: http://eyeonoracle.blogs.techtarget.com/2007/09/10/are-you-afraid-of-hosted-apps/?track=NL-333&ad=602935&asrc=EM_NLN_2189641&uid=6473080

Puzzled. Usually if I find a slow running query in a stored procedure, I lift it out and run it in sqlplus or TOAD etc and tune it from there.
Today I am looking at a query which, when declared in a procedure like this: for h in (select ......) loop ..
end loop; takes 3-4 seconds to parse and execute - i.e. if I stick a trace line before the for and after the loop line, the first row becomes available after 3-4 seconds.
Lifting the SQL out and running in sqlplus, it takes < 0.5 se.... read more

Can someone point me to some resources that explain how MySQLoptimizes VIEW queries? I have some complex queries that uses sums and unions that draw fromviews. I'm working on speeding it up, and one thought that occurs tome is that selecting directly from tables themselves might speed itup. But, MySQL could already be doing this -- decomposing view queriesdirectly into tables -- thus making my optimization attempt migratingto tables redundant.
Or is there a big speed difference between sele.... read more

I am having some trouble starting up an instance of my Oracle 8.1.7database on a Solaris box.
I set the Oracle SID, go to the appropriate directory and here's whathappens ...
Oracle Server Manager Release 3.1.7.0.0 - Production Message 4505 not found; No message file for product=SVRMGR,facility=MGR ORA-12545: Connect failed because target host or object does not existSVRMGR> How can I get a list of valid objects/hosts? I'm thinking I didn'tsset the ORACLE_SID variable properly..... read more

Hello, I am importing a large database to Oracle 9i. I have a simple script to create tablespaces and users and everything I need. When I look at the log at the end of the process, I find that a bunch of stuff did not import, and error 1659 (unable to allocate MINEXTENTS beyond X in tablespace Y) was returned. I thought this might be a space issue and I will try and increase the allocated space for each tablespace, but first I thought I would post here since I am relatively new to Oracle. Shoul.... read more

I've read the developers page regarding views on mysql and I've also found that other people have had problems with creating views and permissions but I still have a question as to how I achieve this.
I create a database using JDBC in my java program. Everything works fine (creating tables) but when it gets to creating the view I am told that I don't have enough permissions. This is doing it as normal user.
For usability reasons I would like to be able to do this as normal user, is.... read more

Is there any table I can query to find out the operatingsystem(Linux/AIX etc) from pl/sql?

I'm trying to compile the perl module DBD::Oracle. It's giving me an error that says I probably need to install more components. I've goodled for that error message and I've found that it means you have to install some things called pro*c and rdbms.
Well, I need to to a silent/non-inteeractive install of Oracle because I'm blind. And I can't figure out how to install those components via the sample response files on my CD.
Does anybody know what Oracle 9.2.0.1.0 compone.... read more

I have tried installing MySQL on RedHat 9 using instructions in INSTALL-BINARY and am getting the following error when trying to finish installing and testing MySQL :- ~~~~ $ ./bin/mysqladmin -u root -h yyyyyyyy.com password 'xxxxxxxx' ./bin/mysqladmin: connect to server at 'yyyyyyyy.com' failed error: 'Lost connection to MySQL server during query' ~~~~ The previous command :- ./bin/mysqladmin -u root password 'xxxxxxxx' worked fine.
Hope yo.... read more

Hallo, I have a full pump of a db with schema s1.
Now I want to make a impdp to the same database but to schema s2.
Is this possible to do? Werner

Can somebody help me with the processof upgrading the Oracle Database server from 8.1.7.2 to 8.1.7.4 ? Thanks, Ram.
****************************************** This message was posted via http://www.oraclemonster.com* * Report spam or abuse by clicking the following URL: * http://www.oraclemonster.com/Uwe/Abuse.aspx?aid=73db04a468ad4c33876f738804693df2*****************************************

I need to grant a user the ability to recompile invalid views onanother schema.
For procedures/functions/packages is is simple: grant alter any procedure to xxx But this does not include views, and I see no way to grant a similarprivilege for views. Evengrant create any view to xxxis not good enough Onlygrant alter any tableis sufficient, but that is a little bit too much for recompiling aninvalid view TIA

Could someone confirm or answer whether Oracle 9i has the followingfeatures? * Can we define several user function (CREATE FUNCTION) that have thesame name but with different signature (for example, REVERSE(varchar)and REVERSE(blob))? * computed field/column is not supported, use VIEW for that purpose; * Can columns on a VIEW be indexed? * Only READ COMMITTED and SERIALIZABLE transaction isolation level aresupported; READ UNCOMMITTED and REPEATABLE READ are not.
* Can a unique index accept mult.... read more

eDiscover

Click the logo to go back to the main page

Databases

Search eDiscover

Categories