03/07/2018 11:47
Hi anybody,I was getting error like below while compiling packageORA-04021: timeout occurred while waiting to lock object start1.stplease assist me.

6 answersclick here to view

02/07/2018 11:47
Hi ich habe eine Oracle 9i installiert. Auf der DB soll eine Webanwendunglaufen. Der Code f=FCr die Anwendung ist ok. Hab schon =FCber SQLPlus dieZugangsdaten gecheckt und die gehen alle.
Bekomme aber dennoch die Fehlermeldung 0RA-12637 Abruf desBerechtigungsnachweis misslungen Was und wo muss ich was in der DB einstellen?? Bin bei Oracle einNewbie.
thxThomas

4 answersclick here to view

01/07/2018 11:47
I submit the nomination of Gary Burnore from Databasix for the Gene SpaffordUsenet Samaritan Award for giving out free Usenet to so many people.
(the nomination has to be seconded and thirded) (seconds?) (thirds?)

1 answersclick here to view

30/06/2018 11:47
Hi all,I have exported on table from one DB to another. I have this issue: import done in US7ASCII character set and AL16UTF16 NCHAR charactersetimport server uses WE8ISO8859P1 character set (possible charsetconversion)export server uses US7ASCII NCHAR character set (possible ncharsetconversion) I have found an interesting article which explains how to indentify acharacter set: http://www.dbaoncall.net/references/ht_identify_charset.html but I haven't found which are the right steps to avoi.... read more

4 answersclick here to view

29/06/2018 11:47
10.2.0.2 on Windows 2003 SP1 4.06.001.
History: Last week we ran an import while in archive log mode. Oh well.
The recovery file dest filled up.
db_recovery_file_dest_size - 2GB.
db_recovery_file_dest = D:oracleproductflash_recovery_area We did not need the archive log files at that point, so we shut down,removed the files and restarted.
We took the db out of archivelog mode, and continued on with noproblems.
Yesterday: refreshed all non-system schemas with a fresh import (thisis part of an.... read more

1 answersclick here to view

28/06/2018 11:47
From time to time I am called in to investigate performance problemsas last week.
In this case there was one bad performing query.
Instead of using indexes the optimizer chose full table scans.
When looking at the statistics I thought that the optimizer shouldhave used available indexes here.
In this case my colleagues had gathered new statistics just a weekago.
Looking at dba_tables the last analyzed date was of that date.
But looking at dba_tab_col_statistics there were column statisticsava.... read more

9 answersclick here to view

27/06/2018 11:47
Hi Guys, My company just recently purchased Arcserve 11.0 with OracleClient Agent to perform backup for our Oracle Database. However, I amnot able to expand the oracle database to see the tables in Arcserve.
It will just keep prompting for username and password. I'm pretty sureI enter the correct credentials at the setup process. The oracle sysdbaaccount I provided to the agent is definitly working. Anyone hassimilar issues? Regards,Mike

1 answersclick here to view

26/06/2018 11:47
I have a database in Oracle 9i. I want to backup the structure and data insome *.sql file. Can sqlplus do this purpose for me?? and How to do? Thx

3 answersclick here to view

25/06/2018 11:47
I am an independent consultant specializing with ORACLE products forlast 14 years. My goal is to form a teaming arrangement with ORACLEprofessionals, who wants to earn some extra cash on the side and builda strong business relationship with me. I have been marketing throughhttp://www.sirc.net as an ORACLE Solutions Provider. My company is an8a certified, Women Owned, has a GSA Schedule with excellent pastperformance for the last 9 years.
Your role would be to refer a client, help me close the d.... read more

4 answersclick here to view

24/06/2018 11:47
I have a trigger that calls a stored proc on update for table1. Whenthe stored proc queries table1 it can not see the new data. The usermodifies the TIME column, but the proc still queries the old data. Howcan I fix that? Trigger: CREATE OR REPLACE TRIGGER trigger1after update on table1for each rowdeclare pragma autonomous_transaction;begin proc1 (:new.name); commit;end; Stored Proc: create or replace procedure proc1 (v_name varchar2) as cursor c_tbl is select id, name, time from table.... read more

7 answersclick here to view

23/06/2018 11:47
All,We can get this by analyzing the tables in a schema and looking at thecolumn avg_row_len.
But, is there a sql so that I can calculate manually. In outenvironment, we gather statistics once and use them all the time.
Thanks,Naga

2 answersclick here to view

22/06/2018 11:47
1) using locally managed tablespaces with uniform extent sizes meansthat it is physically impossible to have fragmentation.
2) using dictionary managed tablespaces but create all objects with initial=next and pctincrease=0 and keep all same sized objects inatablespace together, fragmentation is minimized (1) is very clearcut... but my conerns are with (2) since right now, ihave huge databases around 1.5GB that are on DMT. My thoughts are thatit is easy to keep the initial=next and pctincrease=.... read more

3 answersclick here to view

21/06/2018 11:47
Hello, I have problem with enabling archivelog mode in Oracle 9i database. When I am trying to enter archivelog mode (with stanadard: startup mount exclusive; archive log start;) I got Oracle Data Guard is not available in this edition of Oracle. I do not want Oracle Data Guard (in Oracle 9i SE it's not available). I want to put my archivelogs on local machine.
I have standard archivelog parameters: LOG_ARCHIVE_START=TRUElog_archive_dest=/u02/oradata/arch/log_archive_format = archT%TS%S..... read more

1 answersclick here to view

20/06/2018 11:47
Oracle 10.2.0.1.0 on Solaris 5.10 Does anyone know what the wait event 'reliable message' means? A search of MetaLink turned up 6 hits, 5 of which were from the forum,and all 6 hits only because it was in a list of wait events.
A serch of this newsgroup turned up many hits, but the same end result.=2E. it was simply part of a list of events. No explanation.
It is not listed at all in the 'wait events' chapter of the Oracle=AEDatabase Reference10g Release 2 (10.2).
We're in.... read more

4 answersclick here to view

19/06/2018 11:47
Hi All, I have a query in which I need the first column to basically be therow number. This is not the ROWNUM psudo column, just simply acounter. The query is below. I basically need the number of the rowin the result set.......
Any ideas how I can implement this into the current query??? Thanks for your help.
SELECT NULL, m.comp_name, m.ticker, NVL(sd.avg_rating,-9999),NVL(ROUND(sd.avg_rating_pr,2),-9999), NVL(sd.num_up_rating_1w,-9999),NVL(sd.num_dn_rating_1w,-9999)FROM master_tabl.... read more

2 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 informationWe 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