14/08/2018 11:47
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

2 answersclick here to view

12/08/2018 11:47
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

5 answersclick here to view

11/08/2018 11:47
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

4 answersclick here to view

10/08/2018 11:47
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

3 answersclick here to view

09/08/2018 11:47
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

1 answersclick here to view

08/08/2018 11:47
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

4 answersclick here to view

07/08/2018 11:47
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

4 answersclick here to view

06/08/2018 11:47
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

2 answersclick here to view

05/08/2018 11:47
Is there any table I can query to find out the operatingsystem(Linux/AIX etc) from pl/sql?

6 answersclick here to view

04/08/2018 11:47
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

5 answersclick here to view

03/08/2018 11:47
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

7 answersclick here to view

02/08/2018 11:47
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

1 answersclick here to view

01/08/2018 11:47
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*****************************************

3 answersclick here to view

31/07/2018 11:47
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

5 answersclick here to view

30/07/2018 11:47
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

3 answersclick here to view

eDiscover
Helpforce eDiscover provides technical articles updated each day
Click the logo to go back to the main page
Databases

Helpforce eDiscover RSS feed contains the latest technical articles in RSSWe have a vast archive of technical informationA database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. This category deals with general databases and more specific vendor products such as MySQL and Oracle.

Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS