PL/SQL :: Oracle 11g On Linux - Collapsing Rows
Jan 28, 2013
Oracle 11g on Linux. Previously submitted as Matching Rows.
I have the following table.
create table p
(pid varchar2(10),
first_name varchar2(10),
last_name varchar2(10),
type_code varchar2(5)
);
[Code]....
I used SELECT *
FROM (SELECT pid,
first_name,
last_name,
type_code,
COUNT (*) OVER (PARTITION BY first_name, last_name, type_code)
cnt
FROM p)
WHERE cnt > 1;
to get only the rows 1A and 3A
PID FIRST_NAME LAST_NAME TYPE_CODE
1A DENNIS ALRIDGE G5
3A DENNIS ALRIDGE G5
but, a new requirement is to get it in the format:
PID1 FIRST_NAME1 LAST_NAME1 TYPE_CODE1 PID2 FIRST_NAME2 LAST_NAME2 TYPE_CODE2
1A DENNIS ALRIDGE G5 3A DENNIS ALRIDGE G5
I tried mod(rownum,2) != 0 to separate the row numbers, but the output is offset with null like:
PID1 FIRST_NAME1 LAST_NAME1 TYPE_CODE1 PID2 FIRST_NAME2 LAST_NAME2 TYPE_CODE2
1A DENNIS ALRIDGE G5
3A DENNIS ALRIDGE G5
How do I collapse the rows?
View 8 Replies
ADVERTISEMENT
Aug 8, 2012
We would be moving oracle 11g unix sun solaries to oracle 11g Linux readhat OS. what would be the disadvantage and what are the item needs to be verified. Basically advantage of oracle 11g Linux readhat OS.
View 2 Replies
View Related
Jan 20, 2011
I am unable to configure EM(Oracle 11.2g) on Redhat Linux 5 Enterprise edition(32 bit). Environment variables are set to correct SID. If I try to run dbca the wizard does not display the Enterprise manager configuration screen. I have tried to create repository by using emca -config dbcontrol -db config.
But it throws exception that database instance is unavailable?
View 5 Replies
View Related
Feb 25, 2012
how to install oracle on Linux.
View 2 Replies
View Related
Jul 25, 2012
SQL>startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initora11g.ora'
Unfortunately I can not find initora11g.ora
[oracle@localhost db_1] cd dbs
[oracle@localhost dbs] ls
hc_orcl.dat init.ora lkORCL orapworcl spfileorcl.ora
so create pfile from spfile='/home//oracle/product/11.2.0/db_1/dbs/spfileora11.ora will not work
[oracle@localhost dbs]$ ls
hc_orcl.dat init.ora lkORCL orapworcl spfileorcl.ora
I don't see initora11g.ora file - as shown above in oratab also - it showed sid as orcl but I changed into
I have set oracle_sid = ora11g in .bash_profile as well
View 1 Replies
View Related
Nov 18, 2012
share with me a linnk of oracle 11g client on RHEL 5 32 bit due to i search in oracle web site and found only 64 bit URL.....share with me a link of installation guide of this client?
View 4 Replies
View Related
Jul 18, 2013
link where can i get oracle 9i for Linux OS??Is 9i available for 64 bit ?
View 4 Replies
View Related
Oct 22, 2012
I have installed oracle enterprise linux 6.2 on my laptop, and I installed the database 11gR2 on it, know the user account I used to log in with (os level) is not accessible any more :
[URL].........
if I remove the account and recreate it does it will cause problems to the database?
View 5 Replies
View Related
Nov 20, 2006
I get this error when trying to log in to SQLPlus in Oracle
ERROR:
ORA-12516: TNS:listener could not find available handler with matching protocol stack
View 1 Replies
View Related
Jun 15, 2011
During installation of Oracle RAC 11g r1 on Linux using VMware server for Two Nodes, all the pre cluster installation test was successful, and execution of root.sh on node 1 was successful too, but whenever I run the root.sh script on the second node I get error message "Failure at final check of oracle CRS stack. 10"
View 3 Replies
View Related
Jul 19, 2012
Looking to install oracle 10g in same server where i have installed already oracle 11g,
: i have looked at how to install oracle 11g and 10g on same linux server.but didn't quite get it ....
View 15 Replies
View Related
Jun 5, 2012
URL.....Where can I download Oracle database express edition for x86 Linux? I can only see Windows and x64 Linux in Oracle's download page URL....
View 2 Replies
View Related
Aug 9, 2012
Can I install Oracle XE 11g on Oracle linux 6 (x86_32). Where can I download XE rpm?
View 3 Replies
View Related
Nov 14, 2006
When I was installing the oracle DB and instance in my linux server, I chose not to use oracle EM to administer it. I want to add the EM now, may I know what is the procedure?
If I want to use oracle EM installed in another server (for example oracle windows server) to administer it. May I know how to install just the EM remote agent in the local linux server ? what is the procedure?
View 1 Replies
View Related
May 1, 2010
I have configured and tested the webutil in Windows Operating System and worked perfect, Now i am trying to deploy customized form to EBS R12 that using webutil, and after making same configuration which has done before, i got compilation error.
Form is very simple(Just button with following pl/sql code)
show_webutil_information (TRUE);
Erro is: "FRM-40039: Cannot attach library WEBUTIL while opening form XXR12_DEMO.fmb"
webutil configuration steps on R12 or the error solution,
View 1 Replies
View Related
Nov 29, 2010
I understand how to create a database directory object to point to a directory on the server File System. Is there a way to take the next step and create a new directory on the host file system from within Oracle?
View 8 Replies
View Related
Aug 28, 2013
Is it possible to take export import to the Oracle DB/Schema/Table from other linux user? i have plan to create dummy user like oracle on Linux box, so developer will use this dummy user and logging to oracle BOX and take the dump. I have created one user "TEST" in linux OS. but what is the next? what privilege is required or take dump from other linux user?
oracle:x:501:502::/home/oracle:/bin/bashtest:x:502:504::/home/test:/bin/bash
View 19 Replies
View Related
Oct 25, 2013
What are reported issues when migratin Oracle 11g from Solairs to Linux?
View 1 Replies
View Related
Apr 13, 2013
can we import oracle 10g database table into oracle 8i database on linux platform?
View 7 Replies
View Related
Feb 10, 2010
We are planning to migrate the forms application from windows to linux.
View 1 Replies
View Related
Jun 22, 2012
Question: to migrate from oracle 10gR2 in Windows to oracle 11gR2 in Linux . Steps are:
1. need to expdp all schemas/users from oracle 10gR2 in Windows,
2. then impdp each schema/user into oracle 10gR2 in Linux first,
3. then upgrade the oracle 10gR2 in Linux to oracle 11gR2 in Linux ?
4. Do I need to pre-create all the same tablespaces first in oracle 10gR2 in Linux ?
Is it correct ? or I can migrate straight all schemas/users from oracle 10gR2 in Windows to oracle 11gR2 in Linux using impdp ?
View 5 Replies
View Related
Dec 28, 2012
I have a Linux box with the below configurations:-
Linux blrulvremoradb02 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
Last time my UNIX administrator have done a partition in this box. I have 100GB lun allocated to this box which is spilitted in two mount points.
/u01 is having 30GB and /u02 is having 70GB. I want to build a ASM in this box and install Oracle 11.2.0.1 and for that I need raw disk.
Is there any useful links or can you guide me to achieve this... My UNIX admin is on leave for new year and I want to do this by my own..
View 5 Replies
View Related
Nov 12, 2012
We have a scenario where Oracle Database R1 is installed on Windows System and the Client is present on Linux. Both the system is on same network. We can access Windows -2-Windows using TNS entry.
I am unable to connect to this scenario where Database is on Windows and Client is on Linux.
View 8 Replies
View Related
Sep 19, 2013
What are the free linux OS's that are suited for running Oracle 11g smoothly?
View 17 Replies
View Related
Jan 11, 2011
I need to setup Oracle 11gR2 single node @ Linux RHat 5 64-bit for long performance tests, huge loads, high speeds, a lot of transactions, having a good scalability, etc.
It's not a production server, but for strong system/volume tests.
CPU
Motherboard
Memory
HDD
Network
View 2 Replies
View Related
Nov 12, 2012
Issue : NOT able to start the Oracle Data Base 11g on Linux machine
I've successfully installed Oracle-DB-11g on my Linux machine.
Note : I haven't declared or exported any variable(s) , actually I'm not sure how and where to do this.
View 1 Replies
View Related
Oct 25, 2013
Migration of oracle forms 10g 32 bit windows platform to 11g 64bit Linux platform . I have about 500 fmb on my 10g environment which are currently working fine but when i go to compile it on 11g an error file is generated. All my path is set in proper manner .
I have a object library which has multiple tabs and every tab has its own object. While compiling, the forms are not inheriting the object values only few values from the object are considered.
View 5 Replies
View Related
Mar 16, 2012
A link which describe step by step with screen shots how can i install oracle 10 r2 on oracle linux server release 6.1 using vmware workshop 8.my actual os is windows server 64 bit in this in install vmware 8 and i install oracle linux server release 6.1 32 bit now i want to install oracle 10g r2 or oracle 11g r2 on this .
View 2 Replies
View Related
Dec 10, 2012
Env destination-linux:2.6.18-308.13.1.el5,oracle:10.2.0.1 ,source:windows.mssql v:8.00760
I was try migrate one sample database from mssql "Pubs" using Oracle SQL Developer Tool.
After migraton i've got prefixes in tables like MD_<table_name> but i can not see tables from Pubs only a lot of tables like :
MD_COLUMNS
MD_GROUPS
etc...
View 10 Replies
View Related
Mar 29, 2013
RPMS needed by OCFS2 for oracle enterprice linux 6.2,Since we unable to mount through OCFS2 console.
View 1 Replies
View Related