29/12/2018 11:47
I am using IBM AIX 5.1L and ORACLE 9.2.0.2 I moved the database from one machine to another machine using COLDBACKUP...i.e alter database backup controlfile... and then moved thefiles from one server to another etc etc...
BUT when I start my database I get following : SQL> startup;ORACLE instance started.
Total System Global Area 404193456 bytesFixed Size 741552 bytesVariable Size 369098752 bytesDatabase Buffers 33554432 bytesRedo Buffers .... read more

2 answersclick here to view

28/12/2018 11:47
Is anywhere on the net script for using OLS on 9.x platform?? Oracle 10g include OLS option so there is no need for additional scripts..

1 answersclick here to view

26/12/2018 11:47
Hi.
I need to create a trigger that when raised, creates a XML filereflecting all the data of a table. I can do that using SQL Server butI am fairly new to Oracle. My Oracle version is 8.1.7.
Can I do that or do I need to consider another approach? This XML fileis very important to the application I am writing! Thanks,Robert Scheer

4 answersclick here to view

25/12/2018 11:47
Hi,I have a database on Oracle 9.2. in schema TEST there're tables: zamowienia_pozycje and stawki_vat.
While executing insert command:: INSERT INTO ZAMOWIENIA_POZYCJE(ZAMOWIENIE_ID,OPERATOR_ID,POZYCJA_ASORTYMENTOWA_ID,POZYCJA_CENNIKA_ID,CENA,WARTOSC_WSPOLCZYNNIKOW,STAWKA_VAT_ID,STATUS_POZYCJI_ZAMOWIENIA_ID,LICZBA_SZTUK,ZLOZONA_NAZWA_POZYCJI)VALUES (4,1,6,1,2,1,1,1,1,'test') Oracle throws an exception: ORA-02291: Integrity constraint violated (TEST.ZAM_POZ_STAWKA_VAT_FK)- parent key .... read more

5 answersclick here to view

24/12/2018 11:47
Hi, I have a function with the following signature : FUNCTION FP_NEWFORMAT(searchKey VARCHAR2, QTY NUMBER) RETURNAVA_COLLECTION PIPELINED; basically the number of lines in the function has now exceeded 200lines which means it is unreadable (almost). What i need to do isrefactorise this function, effectively splitting it up into subfunctions called from this main application.
How would i go about doing this.
I'm contemplating creating sub functions that are also pipelined andusing the OPEN.... read more

5 answersclick here to view

22/12/2018 11:47
hi, I should say that I am mainly a SQL Server person and am entering astrange world. I do not know much about tuning Oracle databases.
I have a table structured like this: deleted char(1)transNum intobjectId char(32)some other columns The table retains history of an object by inserting a new row for eachchange, thus a specific object could have hundreds of tuples, eachwith a different transNum.
Our application does 2 types of select: 1) An entire section of current rows: select * f.... read more

3 answersclick here to view

21/12/2018 11:47
I used to use an rather expensive product to monitor locks on my databaseinstances.
The product gives me a detailed view of who locks who. For example, it cantell you that session 123 is waiting for sessin 456 which is itself waitingfor session 789 to release a lock. It also tells me for how long session Xwaited for session Y.
It gives you the OS Server process ID as well, and it is now easy to callthe user who did not commit it transaction to release the lock and let theother transaction proc.... read more

2 answersclick here to view

20/12/2018 11:47
I have a task that is undoubtedly common, simple, but not trivial.
I have a number of tables with minor variations, but basically what happens is this. Each row has a start date and an end date. The rows fall into sets, within a set of rows there can be at most one row that does not have an end date (i.e. active). An example is below, to clarify this.
I want to accomplish two things.
1. I want to define a constraint that enforces the rule of one-or-zero active rows per set. How to do this.... read more

1 answersclick here to view

19/12/2018 11:47
I am *very* pleased to present this link: http://www.oreilly.com/catalog/oracle9ipdf/ Best regards, Jonathan GennickEditor, O'Reilly Media906.387.1698 mailto:jgennick@oreilly.com

5 answersclick here to view

18/12/2018 11:47
I have the following sql select code in a .asp page which I'd like toconvert to a stored procedure on an Oracle 9i schema: Set conn = Server.CreateObject(ADODB.Connection) conn.Open Application(connstring) strSQL = SELECT P.ID, P.FIRSTNAME, P.DSSURNAME,TO_CHAR(P.STARTDATE,'YYYY/MM/DD HH24:MI:SS') AS STARTTDATE & _ FROM PEOPLE P & _ WHERE (P.FIRSTNAME = ' & strName & ') & _ AND P.DSDELETED = 'No' Set rs = conn.Execute(strSQL) My Oracle pr.... read more

2 answersclick here to view

16/12/2018 11:47
Can you tell me if I install an oracle 9ias infrastructure database.
which type of database will it be? Enterprise edition or standardedition.
Also, when I connect to a oracle 9i database application. Is thisapplication database can be a standard edition or it must be aenterprise edition..? Thank you.

2 answersclick here to view

15/12/2018 11:47
Hi, I have a table where dates are stored as numbers (seconds since1/1/1970) and I want to generate a query to show them as dates with theformat DD/MM/YYYY hh:mm:ss.
Which conversion functions should I use? Thank you in advance.

1 answersclick here to view

14/12/2018 11:47
I had a long-running batch job on a dedicated server that had beenrunning for three weeks. It's written in Python, and failed with FAILED: OperationalError(2006, 'MySQL server has gone away') while doing a LOAD DATA INFILE.
The MySQL server is local. It hadn't failed, and remainedup. There was no KILL executed; the server shows zeroKILL operations since startup. The LOAD DATA INFILE succeededon retry, so nothing was wrong there.
But the server was heavily loaded .... read more

3 answersclick here to view

13/12/2018 11:47
Please, I am a Newbie. My aim is to upload documents, categorize themand add some metadata and store them in MySQL for later querying andretrieval. I have found a script which upload documents and storethem, but I really can't understand how to add metadata likecategory uploader date_uploaded to each uploaded file.
I hope to make this as easy as possible. Here is my script forprocessing the uploadform and store the uploaded file: <?phpif(isset($_POST['upload']) && $_FILES['us.... read more

1 answersclick here to view

12/12/2018 11:47
I have a table defined like: CREATE TABLE ORGS(NUM INTEGER NOT NULL,ID INTEGER NOT NULL) In the table I have like: num id41 541 641 799 589 9 I was wondering if there is a method where I can generate a resultdataset from a sql query that looks like: 41 5,6,799 589 9 My approach currently is to iterate over the result dataset to producethis.
Mike

10 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