Hot Solutions

I am trying to read a file on a ftp server..

I compiled the package provided in sdstuber's blog..

http://www.experts-exchange.com/Database/Oracle/PL_SQL/A_3043-How-to-FTP-with-Oracle-PL-SQL.html


when I execute the following piece of...

Folks

Probably done something stupid but can't figure it out.

When trying to startup my database I get the following message:

 
the init.ora reads as follows (pretty basic)

 
I guess <ORACLE_BASE> got messed up (where should I check...

Help please need to count times action used each month:

Select
to_char(action_date,'yyyymm') as month,
count(action_number) and count,
case
when action in ('sn') and result in ('mm') as 'sn/mm'
when action in ('sn') and result in ('nn')...

Hi Experts!

My apology for question not being  clear, as any perfectly formulated question by itself shows an answer.

Im designing database in SQL Server. Not taking into consideration all other Entities, I have two. One entity is...

I am trying to setup a PHP (Ubuntu) server to connect to an Oracle database.  Installed oci8 PHP extension by following these directions:

https://help.ubuntu.com/community/PHPOracle

When I try to make my connection with oci_connect, I get:...

Hello,

I'm from a C#.NET 4.0 + Linq background and I just started with PL/SQL.  I am trying to query a database and obtain two values which I can then use in my C# code.  

Here is the C# code I have so far:


string sqlstmt1 = "SELECT...

We need to upgrade our Oracle database from 9i to 10g.  We've performed the upgrade on the test box and are in the process of checking it for issues.  

One thing that's popped up so far is the error: "Oracle ORA-01855: AM/A.M. or PM/P.M." for...

Hi,

Im facing this problem during a sql statement:

Statement: begin
              if upper('dpow_1a') <> upper('dpow') then
                 grantToInstanceUser('dpow_1a');
              end if;
           end;

Exception message:...

I installed SQLDeveloper 3 on Windows 7 and trying to connect to the database 10g R2 I get the following error: Ora-01882 timezone region not found. I can access the database from sqlplus, no problem.
I did the following:
in sqldeveloper.conf,...

Oracle 11G OracleDBConsole Service not Starting

OracleDBConsole Error Category 2 Event ID: 6
An error occured while trying to initialize the service.  


dbconsole exited with retCode 0


problem started after changing  password of...

Is there any way to check if schemaA has given execute on a package schemaA.schemaApackage to schemaB ?

I can do similar check on tables:
select grantee, owner, grantor, privilege from dba_tab_privs where table_name = 'MYTAB'
and grantee =...

RMAN> backup full database format '/u01/app/backup/%d_%U.bkp' plus archivelog format '/u01/app/backup/%d_%U.bkp';


Starting backup at 10-MAR-12
ORACLE error from target database:
ORA-00258: manual archiving in NOARCHIVELOG mode must...

Hi

I have a set of data with the following results - how do I evaluate the previous record data for bunch of columns based on a group value.

Group_id    customer     flag1    flag2       flag3
1                 Netflix          Y        ...

I have Oracle 10 running on a Server 2003r2 Virtual Machine (VMWare ESXi) and I would like to copy that Virtual Machine and rename it.

What happens to the Oracle Server installation (and it's instance) on the new machine, with a new server...

Can sybase IQ 15.4 version or later read .dmp file from Oracle 10g?

we are upgrading to Ms Access 2010 from Ms Access 2003
and from Windows XP to Windows 7.

An Oracle 10g database is use to link to MS Access.

Oracle is not installed on the new workstation.

Where do I get the drivers to link from Oracle...

Hi,

Im trying to set up Oracle using ASM. Installed it like this:

Oracle  was installed using 11GR2 patterns.

Two users created:  grid for infrastructure and Oracle for the DB

-      Instance ASM: (Infrastructure).
ORACLE_SID=+ASM...

Hi Experts

I’ve been trying to install Oracle XE 11g and I keep receiving the infamous error

could not connect to 127.0.0.1:8080

I’ve tried a few things and been over what seems most of the internet but I can’t quite get to the bottom of...

Hi,


I have a shell script, which needs to be sceduled by autosys..
Autosys uses oracle as user and runs teh shell script..

In the shell script, i have a code like this

uid= a; export a;
pwd= b; export b;

$Oracle_home/bin/sqlplus ...

Xperts -

I got the above error when I was importing multiple datapump files on another server.
The expdp was using filesize option which creates multiple files each 20G. It worked last month but not now.

impdp \'/ as sysdba\'...

Hi Experts,

I have developed an interactive report in Oracle APEX 3.2.When we try to download the report in CSV file it shows large number into exponential form in CSV.
For example there is account number 04460414497 in report but in CSV it...

I want to Install dmp printer (EPSON LQ 1150) dot metrix printer On solaris 10.5  and iwant to configure with the oracle R12 .

1 . INSTALL network   dmp printer (EPSON LQ 1150) on solaris 10.5
2. I want to print through server
3. After that...

I am using Windows 7 Enterprise (64 bit).  I am attempting to connect to an Oracle 10g database using "PLSQL Developer".  I get the error message "ORA-12154: TNS: could not resolve the connect identiifer specified."

I have the database...

Q. How do I insert data into newly created database tables having relational constraints to one another?

I am currently running Oracle EE 10.2.0.5.0 on Sun OS 5.10 Sun box and need a tool to schedule SQL script jobs to run against the database at night, weekly, monthly and quarterly.    I want then the output to save automatically to csv or txt and...

I just want to confirm if Oracle11g R2 is certified on Window Server2008 R2.
I tried to find the answer from oracle.com downloads.
Or Which Oracle version can be installed on Windows Server2008 R2 64?

I need some help with a query that I can't quite figure out. I am trying to get a DISTINCT list of CODES with a NAME given that the NAME has multiple values.

I don't care what NAME it uses just that it gets one but the CODE should be unique.
...

Hello,

Is it possible to Upgrade rman catalog 10.2.0.4 on 11.2.0.3 from rman client?

Thanks

bibi

Add standby log file

SQL> select group#,member from v$logfile;

    GROUP#
----------
MEMBER
--------------------------------------------------------------------------------
         3
/u01/app/oracle/oradata/orcl11/redo03.log

      ...

Hi Experts,

I am using Oracle APEX v 4.0

I am using the standard SQL Report. The query is based SQL created in a function that creates a dynamic query.

Since the SQL is created dynamically, the headings are also created dynamically. I...

Hi,
I need a very quick query in Oracle.

data is as below in CLOB field is as below:

(CLOB) A<1,?,'providerInfo'='0001\\601\\1601296.dat','storageProviderName'='ExtShared','subProviderName'='Default'>

and i need only output
...

i am trying :
ALTER DATABASE DATAFILE                                                    
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\USSDEV\QT_TBLSPC5.DBF' RESIZE 1M;
i get:
ORA-03297: file contains used data beyond requested RESIZE value
i ran:...

My Email Service provider application allows me to use Oracle SQL to create a new table and I have the table

Main contact list

email_address_ product_id
justin@email.com 1234
justin@email.com 5678
joe@email.com     1234

product_id...

Hi,

We are executing 2 PL/SQL statements on our Oracle 10g server and we are getting some interesting results.  The first piece of SQL takes over 1 minute to run, the second piece of SQL takes about 0.1 seconds.  We have repeated this on...

Hi experts

what is the meaning of the following statmetn in batch file xyz.bat ?

sqlplus /nolog @move_data.sql

pause

Hello all,

I am using the Oracle.DataAccess.Client to call a stored procedure that takes a long time to run.  I have not set the CommandTimeout of this call yet.  My question is app is returning errors such as:

ORA-03135: connection lost...

I am trying to establish a foreign key relation ship to a table as per the below script and it is throwing the below mentioned error..

ALTER TABLE DW_EVENT_DOM_DIM ADD CONSTRAINT USER_DOMAIN_DOMAIN_FK
    FOREIGN KEY (DOM_ID)
    REFERENCES...

Hi,

I have the following union query:

SELECT
      'BECKWITH' as 'SLC',
      SOI,
      Cast(RTrim(substring(supplier_description,patindex('%-%',supplier_description)+1,50)) as nvarchar(50)) 'Supplier'
FROM         CEVA5_Compass.dbo.titems_inv...

When I try to connect a primary to standby where listener is configured using a private network ip address in HOST = parameter it fails.  I can connect from the outside using various clients with no problem, but trying to SQLPlus from primary to...

In Oracle 10 I use "Connect By Prior" to show a component structure.

But how do I stop in a branch with a condition?

Level, Number, Type
1,A,1
 2,B,1
  3,C,2
   4,D,1
  3,E,1
 2,F,1
  3,G,2
   4,H,1
    5,I,1

I wish to show the...

I am trying to pull in some information from our database and am having troubles pulling the addresses in due to the formatting of the tables and am looking for suggestions on the best way to pull the information in.

Here is what the table...

I have data in a large database trying to find the first time that user successfully signon.  I need to get the user id, signon date based on specified date range.  For example i want to get userid's for user whose first signon date is between...

I have a RAC evn. with 2 nodes, both instances are up and running
CRS services are fine, nodes are pingable, listeners are up and running fine.
But users are not able to connect to db. It is handing for ever.
Every GV$ views are handing in the...

Hello Experts
Iam trying to make my existing database a PRIMARY database and a database in another server as a STANDBY database. I messed it up when defining the parameter   "db_file_name_convert" in the standby database. Now when i try to...

Hi,
OS: Windows
DB Version: Oracle 11.2

I'm trying to export my schema TOM.

exp TOM/TOM@ORCL file=c:\exp_tom.dmp log=c:\exp.log

but I can export only tables with rows. Each table with zero rows is not exported.

Should I set some...

Good Day!

I am unable to find any indication that IMPDP needs any special commands for importing a DMP file created by EXPDP with the COMPRESSION=ALL setting.

Will IMPDP automatically recognize and handle the fact that the DMP was done with...

while installing RAC I accidently deleted eth1 network
Now I have only eth1.bak

Is there any way to get eth1 network like eth0

in a 2 node rac attempted to install..

Attaching screen shot

Experts -

I'm getting the error when I tried to connect from oracle to mysql via DBLINK.

I guess this is something to do with the User/privileges.

Need some help.

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle...

Recently i upgraded an application from a lower version to a higher version?
now i face the problem that when i try to update the records , it takes more time. previously it was done immediately.

What could be the reason? how can I improve...

I am trying to update the fields in my database by querying for identical tags in another database. Problem is if the query returns more than one matching tag I am currently just picking MAX(). I would prefer to pick the tag which actually has...

I am using the below statement (supplied by sventhan) to query an Oracle database object formatted like;

123456/45
123456   /   50
123456/ 85

select  substr(yourcol,1,instr(yourcol,'/')-1) firstPart,
substr(yourcol,instr(yourcol,'/')+1) ...

Greetings,
I have two tables.
Table A:
Col1 PK
Col2 Fld1
Col3 Fld2

Table B:
Col1 PK
Col2 FK
Col3 Data
Col4 TypCd <--this is a typ code related to data (cause of my headache ;) )

I have Select PK, Fld1, Fld2 from A;
I want to...

I have a stored procedure that I would like to execute by using either a single date or 2 dates and am having s problem getting the syntax correct, maybe its not even possible...??

Calling the script like so.. not even sure if this is the...

I have a query that returns monthly totals for one year from a table. I want to further group these returns per department using "GROUP BY CUBE". This is the table definition:
desc costs
 Name                                      Null?    Type...

Hello,

I would like to know the  format for the default date in a parameter in the data template.

 <parameter name="FROM_DATE" dataType="date" defaultValue="1951-01-01"/>
     <parameter name="TO_DATE" dataType="date"...

i am trying to create a database link between two databases on oracle 11g using the following syntax.

 

it is creating the link successfully, but it is creating with the default domain name . dbl_qd.oracle.db.com.  i do not want the...

Does the {} syntax denote bind variables ?

_queryString = String.Format("select * from table m " +
                               "WHERE m.col IN " +
                                    "('{0}',  '{1}' )"  +
                                ...

Would like to have the following under sql plus prompt:

1) It worked  
>@test.sql ORACLE_SID
where in test.sql, I can put
define ORACLE_SID=&1
...
I do not want this.

2) Since once logging in database, the ORACLE_SID can be obtained...

Hi,

I have a need to backup the structure of my database.  There is a regular backup process that does everything (rman) but what I want is a blank database that has all the structure.

I have thought about using the Oracle DataPump with...

EM Dbconsole is running, but how do I bring out Enterprise Manager console?

I have a table Oracle:
id    F1   F2   F3
---------------------
1     20   30   40
2     10   15    20
3     50   90    12


How could I write a query on the above input to get o/p like this:
id    key     value
-----------------------...

Hello,

I have an ASP.NET (C#.NET 4.0) search form that contains TextBoxes for first name and last name.  I have to query a Oracle database with PL/SQL.  Below is my current query.  If I comment out the ":lastN is null or..." line, then the...

I am looking for free downloadable links for manual, tutorial, checklist, samples, video clips on the latest Primavera.  Appreciate your providing these resources.

Should an initial ERD be in 3rd Normal Form. Or should the normalistion happen latter?

I have a MV that was created as follows:
 

I have also created a MV log as follows:
 

I thought the MV log should be created on tbCardType@KANCARD but it would not allow me to create on the remote table.

How can I update the...

When connecting to oracle from  unix, I am getting this following error.

SP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE may not be functioning properly

Can anyone help to getaway from this.

When trying to audit "drop table", I got the error
>audit drop table;

audit drop table
      *
ERROR at line 1:
ORA-00956: missing or invalid auditing option

Can any gurus fix the error???

Hi All,
I need your assistance. I’m using SQL Loader to append data to a table from a CSV file. When I check the log file, I can see the following messages:

Table OFF_DER_TRANS:
  10575 Rows successfully loaded.
  26 Rows not loaded due to...

how do i just drop the 'with time zone' value from a 'timestamp with time zone' field?
tried this :
select to_timestamp (' 3/15/2012 4:18:53.003000 AM -04:00','mm/dd/yyyy hh:mi:ssxff am tzr') from dual;
i get a ORA-01821..
I dont want to...

Hello,  

I could use some assistance please with formatting the date in the output of an SQL query.  I am able to do what I want, (change column names,etc), but somehow, I am not having much luck on the formatting side.  Using the replace...

Hi All,

I need your assistance. I have a column with about 10000 rows, some of the cells begin and end with ". An example is "this is a test".

I would like to remove the " from the cells. I tried find and replace but didn't work.

Any...

What are the scenarios in which a Database should preferably be made in Oracle as opposed to Sql Server?
In other words are there any limitations in Sql Server in terms of performance, Functionality, etc that are better addressed in Oracle?

I know stuff like redo and archive logs and stuff where there is a lot of i/o should be on what's referred to as fast disks, but i'm wondering about the actual Oracle executables.
Is it necessary for them to be on a fast disk also or does it not...

Hello All,

Here is my scenario ..

I have a 10g (10.2.0.4) Database  - Database A and i have cloned the same Database and upgraded it to 11g R2 (11.2.1.0) Database - Database B.

DATABASE A and DATABASE B has same Schema structure also.
...

Hi

We are going to run a stock reminder campaign.

We have a BIS_requests table which accounts the number of times a Back in stock request has occurred for each product id

contact list table

email_address_ product_id
justin@email.com...

What is connection string for Oracle RDBMS? Should I  continue to use ADO.NET?

Background: My C#.NET application is using ADO.NET (SQLConnection, SqlCommand, SqlDataReader classes) to select data from Microsoft SQL Server database tables. The...

i get this error when i execute a query in .NET

The type initializer for 'Oracle.DataAccess.Client.OracleCommand' threw an exception.

I have the oracle client installed
i have plsql installed and it working with no issues
i have all of...

Hi Experts

I am not sure this is related to OS or Oracle

I have the following expoert script dowing Full Export For Oracle database .
==
exp \"/@epp as sysdba\" FILE=R:\EpprodProductionDBDailyBackup\PPROD_BACKUP_%DATE1%_%TIME1%.dmp...

Hi Experts!

Thanks for reading this.

I have a PL SQL that searches based on days

SELECT * FROM SomeTable
WHERE SomeDateField_DT >= to_date('2012-02-22', 'YYYY-MM-DD')
AND SomeDateField_DT < to_date('2012-02-23', 'YYYY-MM-DD')

How...

Hi,

I need copy a schema located on a 11g database into 9i database, is it possible?
if so how? i tried to export using 9i EXP, but it fails.

it is located on a Windows machine.

Please advice!

regards!

please see attached -

fig a current output (select * from o_questions) and fig B the desired output.

I would like the assessments mee_id to repeat for every row of the assessment (ASM).

So the sql needs to check the assessments...

Hello Experts,

is there a way to run a query in sqlplus and send the results to a local file?
any format would do....

thx....

There available softwares used to recover data when oracle database courpted.

These softwares can access the tables and data inside oracle dbf files without connect to oracle engine or through odbc or oraole

How can access oracle dbf files...

I want to execute a SQLPlus command, set serveroutput on, from within a pl/sql stored procedure.  How is that set up?

Dear Sir,

I am new to Oracle and have a question in my mind about Oracle OPatch tool.
I am using Oracle 10.2 -

(1). Is OPatch a dedicated tool for Oracle Database patching? if not what are the other usage of OPatch?

(2). Can we use...

This is a continuation from question Q_27648088.html
I'm an applications developer. My specialty is developing applications based on the Microsoft Office platform, but I can navigate in Visual Studio too. I am trying to ramp up for a project...

hi guys

I am using oracle sql developer

Under Types i have something defined like this


create or replace TYPE custom_person_map AS OBJECT
    ( id   NUMBER    
    , name        VARCHAR2(19)    
    , active            CHAR(1)
  ...

Dears,

How can I get 12 months data of a year.

In my table i have only the data for January, February & March of the year 2012. and April, May etc are not available and not yet reached also. So in the group by query i need to show all the...

Hi

I have an email address list of 38965 records.

email_address_ cid first_name last_name
justin@email.com 123 Justin Simpson

This is list is supposed to be broken up into 40%, 40% and 20%

I would like to create a new table which...

I have to run a large number of update statements that I am creating using an editor.

Some of the update values contain a single quote in the data string itself.

Some of the update values are a single word, without a space.

Here is my...

My query is below and I had it working but then modified it and now I am getting not a group by expression.  I have googled and know what it means but I cannot see what I have done wrong below.  Someone please help. Either point out the error or...

Hi,

Query attached use wm_concat and this function is not giving the values in correct order.
 '00,' || wm_concat (ev_dt.date_only) as date_only
is the one which is not ordering by correctly.

The inner query which gives "ev_dt.date_only"...

after a huge headache and lots of help from this community, i was able to configure my oracle machine to read from the AS400, i know it works because i can connect to the as400 using isql

isql points to the appropriate odbc settings and i can...

HI iam using ibatis framework and java and i have to store list object to oracle .

1)<parameter property="policyVehiclesList" mode="IN" jdbcType="ORACLECURSOR" javaType="java.util.List"/>
Getting error "Cause: java.sql.SQLException:...

Hi

When I ran the following sql to drop some columns, I got the "ORA-30036: unable to extend segment ". What is the cause and how to fix it?
Our history is a very big table, and it seems take a very long time (> 10 hours to run this sql)
...

i am trying to see if in oracle their is a quick way to get the entire row for old and new values.

I want the trigger to call a procedure, and i want to pass two variable to the procedure

1 would be the the old_row_values, the other would...

I have nested table like this

CREATE TABLE "MMS_STG1"."MMS_AUDIT"
   (      "AUDIT_ID" NUMBER,
      "TABLE_NAME" VARCHAR2(30),
      "DML_TYPE" VARCHAR2(30),
      "MODIFIED_USER" VARCHAR2(100),
      "TIMESTAMP" DATE,
      "CHANGE_HISTORY"...

Hello all,

So I have a pretty easy question but want to see what someone else thinks.  I created a SQL builder type page, pretty cool actually.  One thing I build dynamically is a union statement where the first part of the union will always...