20/11/2017 11:47
Hello, I was working as a trainer(contractor) for Oracle University Turkeyand for their education partners. One of their partners tried to forceme about a training that OUT(Oracle University Turkey) will not knowanything about the education(with photocopy books).
I did not accept it and informed OUT about this situation. But theydid nothing about their partner and reduced the number of my Oracleeducations. So i gave up working with Oracle and finished ourpartnership.
I founded my own educatio.... read more

4 answersclick here to view

19/11/2017 11:47
Hello, we have a customer which has an Compaq ProliantServer with 2 PIII 500Mhz CPU's and 1 gig of RAMand Oracle 8.0.5 (Windows NT Server SP5) .
Unfortunately, since installing the new ERP-System whichuses the Oracle-Database, the queries runs quite slow,due to the mass of queries and new function in the ERP-System.
We are disappointed because we thought it would run notso slow, some invoices take 30 Seconds to be created within the ERP.
There can be many factors, that the ERP is running sl.... read more

1 answersclick here to view

18/11/2017 11:47
I've been doing a lot of parallel updates lately, and monitoring themin DbArtisan, which is a third party tool. I am seeing that thesqlplus session which spawns the update becomes blocked, while theparallel slaves are processing. In some cases, SMON and QMN0 becomeblocked as well, and the database seems to come to a screeching halt. I've tried running sqlplus queries to determine who is blocking who,but that too becomes blocked and doesn't come back, so I've not hadany luck wit.... read more

2 answersclick here to view

16/11/2017 11:47
Hi, This is Mandar Purandare , I have two preapproved labor each in EB2and EB3 category Our terms are simple , you need to take care of legal charges and joinus , and that's all Kindly forward your resume in word format to mandar707@gmail.com orcall me for more details on 402 408 3687 or 402 408 6601.
Thanks & Regards, MandarContact - 402 408 6601/ 402 408 3687Email - mandar707@gmail.com

2 answersclick here to view

15/11/2017 11:47
http://news.bbc.co.uk/2/hi/business/4071909.stm IBM or CIA is successfully enter in China and hiring Red ArmyProfessionals as IBM consultants to achieve the ultimate aim ofbreaking of China.
In last 3 years, IBM hired over 30,000 Chinese to get the insideknowledge of China. In New York City, few Chinese from Chinatown are openly told about it.
B

3 answersclick here to view

14/11/2017 11:47
Per the subject line, this drives me bonkers. I have a particularerror message for which I am searching a solution. All I end up withare hits for some moron that wrote...
i=1;while [ $i -le 30000]; do oerr ora $i i=$(($i + 1))done ...and uploaded the output on the internet.
There...now I feel better :)

1 answersclick here to view

13/11/2017 11:47
Hi all, When I generate table scripts with TOAD, the script declares thevarchar2 column size with: varchar2(10 byte) instead of varchar2(10).
The latter is what I'm used to.
Also this script won't run on every (version of the?) database.
Can someone tell me the difference between the 2? thanks Guyon Mor=E9e

4 answersclick here to view

12/11/2017 11:47
I'm using 'make' to rebuild and populate a database that needs a user and password. In the Makefile I've got a line something like: cat data.sql > mysql database --user='fred' --password='secret' ..... Bat I don't want the password to be in plain text and visible in the Makefile. I've tried just saying --password= expecting 'make' to pause while mysql prompts for the password, but it doesn't work.
I'd welcome any suggestions, please.
.... read more

2 answersclick here to view

11/11/2017 11:47
hi all: Recently cursor:pin S wait on X wait event troubles me.
I have two DB Server for a website. Everynight, Server A pushnew data to Server B by one way. Because some security reason, ServerB can not pull data from Server. So, I using following query toinsert data to Server B: insert into table_a@ServerB select * from table_on_server_a; That is: I create a db link on Server A for Server B .
I running this query on Server A without any problem.... read more

3 answersclick here to view

10/11/2017 11:47
I've been charged with taking hot backups of our database. It's Oracle8.1.7 on Solaris 8 (sparc).
I've come up with a RMAN script, but I'm not sure where to tell Oracle toarchive log current. Below is the current script.
run { allocate channel tape1 type 'sbt_tape'; backup format '%d_%u_%s_%p_%t' (database); sql 'alter system archive log current'; backup format '%d_%u_%s_%p_%t' (archivelog all del.... read more

2 answersclick here to view

09/11/2017 11:47
Hi, i have a performance problem for distributing selected data toparallel pipelined functions. The worker-threads are started with hugedelay, because *all* data from base 'select' are fetched first, thenthey are distributed (delayed) to the worker-threads. I want the datato be pumped to the worker-thread right away - while the base 'select'is still busy.
The problem is due to a trailing 'order by column_x' in the base'select'. The reason for that again is, that i.... read more

2 answersclick here to view

08/11/2017 11:47
A newbie's question. How oracle add an index on nested table. F.g.
Table Student: sid sname classes_registed{class_id, class_name} 01 marry {{c1, classA}, {c2,classB},{c3,classC}} Can Oracle add index between sid and class_id, so that if a query givec1, c2, or c3, I can locat 01's whole tuple?? Thanks a lot.

1 answersclick here to view

07/11/2017 11:47
Hi,I need to migrate 500 GB Oracle 9.2.database from one platform (SunSPARC Solaris) to another (Sun x86 Solaris) with minimal outage. Theplan is: 1. Create empty database on the new server.
2. Shutdown application.
3. Run Export on the old server4. Run Import on the new server5. Start application and connect to the new database.
It works fine, just takes too long, even with direct export, importingmultiple schemas in parallel, etc.
Would it be possible to use fast refresheable snapshots (Materi.... read more

3 answersclick here to view

06/11/2017 11:47
db version 9205 We are using rman to do level 0 and level 1 backups through out the month. RMAN also does the archivelog backups a couple of times a day. Is there a report I can run in RMAN which will tell me if I am missing any needed archivelogs to perform a full recovery from the last level 0?

1 answersclick here to view

05/11/2017 11:47
Hi there, I am currently running a mysql 4.0.18 installation on a production server. Now I would like to update the version to catch up with security fixes. On the MySQL site it made the impression to me that 5.0 is ready for pruduction use. But what benefits does it do for me instead relying on a 4.0, 4.1 installation? I fear that my webapp might brake in some points. Is 5.0 significantly faster, or more secure? Thank you for any hints, Merlin

1 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