I have an Oracle 10g server. The hostname and IP address of the server were changed and now the dbconsole service will not start. I know this problem is related to the name/ip change but not s...
Hi.
Does Oracle 10g have a Pivot function?
I need to convert table's rows (values) into columns.
Thanks.
SQL> create directory testdir as '\\servername\x$';
Directory created.
SQL> grant read,write on directory testdir to public;
Grant succeeded.
SQL> declare
2 file_handler utl_file.fil...
I can compile the each procedure individually with no errors, however whenI refresh the package the body displays and X.If I compile the whole package we get 3 errors. If we recompile the bodi...
Hello Experts,
I am trying to load csv file with about 100,000 lines to Oracle 10g expres using sql*loader utility.
It does not work. See below control file, bad file and ddl to create the ...
I have created a function to return a rowtype value.
CREATE OR REPLACE function GET_ITEMDETAILS( ITEMID IN NUMBER)
RETURN itemDetailview%ROWTYPE
IS
rs itemDetailview%ROWTYPE;
BEGIN
s...
I have got two Linux Debian Servers with Oracle 10g:
-------------Server 1:
ii oracle-xe 10.2.0.1-1.1 Oracle Database 10g Express Western E...
Hi, I am using for Oracle 10g R2 database (RHEL 4.0) the cold backup every night, because there is no traffic during night. The database is in Archivelog mode, and I erase the one day old Arc...
I need to run Oracle 10g database/server on 64 bit Windows Vista Ultimate laptop. It appears that Oracle only certifies it to run on 32 bit Vista. From their site: ---This 10.2.0.3 CD releas...
OK, I'm in need of some assistance.
I've installed ORACLE XE onto my works laptop, I followed the pre-installtion instructions from http://orabase.blogspot.com/2006/08/loopback-adapters-for...
oracle db 10g2:
I have 3 databases, I will call them: db1,db2,db3
o I created dblinks using the same ddl on db2 and db3 that allow me to access db1.
o On db2 and db3 I am using a user wit...
I'm running SQL query on MS- Access 2000 which has DBlink to Oracle 9i tables, this works fine.
We've recently we've upgraded from Oracle 9i to Oracle 10G Client only and when I try to run ...
Hello,
When I create a standard user on Oracle9 and conenct with this user I can create tables and views. Doing the same on Oracle10g I can create tables but not views.
Is this correct?...
I am trying to load some data using sqlldr and I am getting a syntax error.
SQL*Loader-350: Syntax error at line 4.
Expecting "(", found "termininated".
fields termininated by '|||'
Here...
Hi!
Is there a way to change the column order from varchar2 to clob in a table and still retain the columns order?
I would prefer to do this without using a temporary table as constraint...
I have two tables A(ID,NAME, ADR, DUPLICATE) and table B(NAME,ADR,ID). I would like to do something like this UPDATE A SET DUPLICATE = 1 WHERE A.NAME= B.NAME AND A.ADR = B.ADR.
Please note ...
I have a table containing a DATE column, which I know does not contain timezone information. The information in this column will always be in EST. I want to write a function that will conver...
On Windows2003 server i need to migrate from 10.2.0.1 to 10.2.0.4 because of a bug, but i cannot find the patch(es) to apply to accomplish this. Anybody out there gone through that process?
select sum(a), sum(b) from table_test
I want to add sum(a) to sum(b) from one table.
this could be like
select (sum(a) + sum(b)) as total from table_test
but If sum(a) is null, the...
hai experts,
i am getting following error. can any one explain how this error come in to the picture.
Starting backup at 04-MAY-08
channel dev1: starting archive log backupset channel ...
We are running an Oracle 10g database on AIX 5.3. We are also setting up a physical standby at another site and are going to implement Oracle Data Guard. All the documentation I have indicat...
Hi,
After starting I've encountered the following error with Oracle 10g Express Edition.
ORA-01033: ORACLE initialization or shutdown in progress.
I then checked the alert_xe.log file and...
I am trying to refresh prod database to test server.... when trying to restore I get file create error.... as below......
I even tried rman duplicate database... but same error.....
RM...
Hi,
I am working with Oracle 10g express. I am trying to connect to the db via SQLPlus. I get the following error:
ORA-01034:Oracle Not Available
ORA-27101:Shared Memory realm does ...
Howdy,
I will try and be as specific as possible. I currently am installing a Cognos Report Server with a Oracle Content Store. RPT01 has two Oracle Clients installed on it, a 32 bit clie...
