Top Solutions

As i do the following steps for sysdba previlage grants to user ,its comes the following error,
So please any one clarify it, how i grant the sysdba previlage to any user with sys login


SQL>connect sys/change_on_install@db

SQL> select *...

Guys

the following code returns information between dates but I want it to return information between exact dates

What I mean is if I have a date range   01/10/05      to     10/10/05   i want it to look at that and not return what is...

The question below comes from this site.  It's an accepted answer.  However, this syntax doesn't work for me.  I get an error on the comma (after carts c,) that I'm missing the SET keyword.  1) Is the syntax below incorrect, and 2) if it is...

Hi Guys we have begun having a problem with many of our computers at work the last few days. When we attempt to connect to Oracle 9i forms (using JInitiator 1.2.23.1 (iirc)) the following occurs:

Internet Explorer has encountered a problem and...

Hi:

I have the following script (partial) and I want to run this script using nohup directing out put to a file. Please let me know how I can print a comment (Something like "row is updated" or "the cumulative sum of rows updated" ) to a file...

in solaris system the the location of tnsnames.ora is searched
First: ".tnsnames.ora" at users's home directory
Second: TNS_ADMIN
third: /var/opt/oracle
Fourth: ORACLE_HOME/network/admin

1. Is this order common for all unix systems
2....

what is the difference between CONTAINS() function and LIKE?
For example,
Does

SELECT * FROM tblMyTable
WHERE CONTAINS(fld1Text, '%food%') > 0

works the same as

SELECT * FROM tblMyTable
WHERE fld1Text LIKE '%food%'

? Performance...

Hi folks,

I have a table already created on which I want to add a partition by range on a date column. I checked for for the syntax on the Net and most of them:

1. Either explain the syntax for partitions specified while creating the table:...

Hello Experts,

I have a colleague that attempted that was trying to install Oracle 11g on windows machine and encountered the following error message:

Environment variable: "PATH" - This test checks whether the length of the environment...

In the following SQL, I want to order a CLOB field.

SELECT * FROM <table name>
ORDER BY <a clob field name>;

However, directly order by a clob field would not work.
I have to convert the CLOB field to VARCHAR2.

For SQL Server...

Hi,

I execute sqlplus myuser/mypassword@myhost @c:\temp\batchtest.sql

In the batchtest.sql, I have this :

spool C:\Temp\test1.txt
@C:\Temp\testphm.sql
spool off
exit


In the testphm.sql, I have this :

DECLARE
tbl_exist...

when i was upgrading from 8i to 10g one of the packages had the code..

if SQL%ROWCOUNT = 0 then
    v_txt := v_program||': '||':  Tables Not Created. Check!!!!;

    RAISE_APPLICATION_ERROR(-20000,v_txt,TRUE);

END IF;

This failed...

Hi,

I have Web Logic Server,  Forms/Reports 11g all installed on my PC with XP.
I created a hello.fmb and generated hello.fmx on my c:\temp

How to run this form?
    What services need to be started 1st?
    What URL to use ?
    Can I...

Q1: first thing i am not sure what is the difference between the "*.sql" file and the "*.dmp" file

Q2: Second what is the difference between
                               Export Table data vs
                               Export Table...

Hi experts,
I get the following error when I want to start sqlplus:

[oracle@localhost ~]$ sqlplus
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software...

folks

in sql i used the right or left function

i.e select right(wonum,3) from workorder

how does it work in oracle?

Hello...
I'm running Oracle 10g (10.2.0.1) on RHEL4. My listener, database and Oracle HTTP Server are up and running. The sole purpose of this database is to run Oracle Application Express applications. The oracle apex applications are all...

Hi,

I have two servers, one with our production database, and another hosting a standby database.  Each also has its own catalog database as well.  I took a full rman backup this morning at 6:30am and used it to restore onto the standby server...

How I can avoid ORA-1405 errors without setting up indicator variable in  the code.If I need to do this then it will require to change many lines of code.I want a workaround.

EXEC SQL SELECT name INTO :name:name_ind from emp where empno =...

In oracle enterprise manager under the alert section I have a critical error name of "Generic Internal Error with a message: "Internal error (ORA-600[qcscbpcbua]) detected in D:\app\administrator\diag\rdbms\orcl\orcl\alert\log.xml

The error...

I want to run multiple statements in parallel not sequentially
dbms_stats.gather_table_stats (ownname=>'RDWDM', tabname=>'TABLE_1');
dbms_stats.gather_table_stats (ownname=>'RDWDM', tabname=>'TABLE_3');
dbms_stats.gather_table_stats...

How to see relationship  table in Oracle using TOAD,
because i must to see relationship  to make view of  tables..
because not me build the database and make tables,
but I have job to make report using crystal report, so for easy way I want to...

Dear Sir/Madam

I have installed oracle 11g onto linux (centOS) and it works fine. But everytimes I reboot linux (centOS), I need to start the database (test) manually.
Why is this happens?

I would like to know how to startup database...

Hi,

I have installed Oracle DB 64 bit on my Windows 7 HOme premium laptop.

I am able to connect to oracle via sql plus and sql developer

However, I am not able to connect through TOAD.

When I launch toad, its not able to find Oracle...

Dear Whomever can Assist:
 
I'm a SAS person to start but have used Personal Oracle (the SQL> prompt) to some degree.  I have never set the accounts up after installing  10g which was really smooth.  I used to use Personal Oracle stuff for...

I want to create/replace the materialized view but i got the following error
ORA-00922 - Missing or invalid option

CREATE OR REPLACE MATERIALIZED VIEW payroll_mvw
REFRESH ON DEMAND
AS SELECT payroll_no
      ,employee_no
     ...

Hi

I attached webutil.pll library by following method

    *  Open webutil.pll, do a "Compile ALL" (shift-Control-K), and generate to PLX (Control-T)

Library is attached successfully, but no any message dialog is appeared to remove the...

What does the OVER PARTITION BY do? I don't understand this SELECT statement and the OVER PARTITION BY.


SELECT                          
    Field1, field2,
    100 * field3/
        SUM(field3)
OVER ( PARTITION BY NULL) field4
FROM

I have a form that has a five checkboxes.  Two of the checkboxes (let's call them box4 and box5) cannot both be checked.  For example, if box4 is checked, box5 will uncheck and vice versa.  I am new to SQL/PL and do not know what to code in the...

I'm spooling to a .csv file using SQLPlus.  Below is my code that I'm using.  Everything works like i want expect for one issue.  When column (PRODUCT.PRODUCT_DESCRIPTION) "c10" has a comma within the text, then the text is seperated at the...

My server running on W2003.

Honestly I never configure my server as email server before.
Then I found the following link which seems might give the solution.
...

Dear Experts,

I know nothing about Oracle Forms 6i, and i have to design a form which will search from a database. I managed to do this.. now i am stuck at one place.
On a selection of a checkbox, i am hiding one set of items and displaying...

what is the diff in two?

i know that to_char used to change into character format and to_date in numeric format but what is the logic?

for eg

select to_char(sysdate)
from dual

select to_date(sysdate)
from dual

i will get the same...

I have a timestamp column in a table that I need back as a date because the Microsoft OleDb provider for ASP.NET 1.1 does not support timestamps. So to experiment in TOAD, I try the following:

select to_date (to_char (SYSTIMESTAMP,...

Hi,

I'm looking to download a Oracle Universal Installer shipping with 9.2.0.5 patchset or 10g. I need it because I'm about to install odbc driver for oracle for windows server 2003.
Any idea where I can find it?

I've been to this site...

I have a JasperServer's scheduled hourly
"RO103" report that automatically emails
me every hour ONLY if it has results.

I got the below at 7pm, 8pm, and 9pm last night.

I then manually ran the "RO103" report
today and it displays "The...

I am using Oracle 11g on Windows Xp Service Pack 2. After restarting my computer and then loading up the database control I get the following error under the Agent connection to Instance:
Status  Failed
Details  ORA-12528: TNS:listener: all...

I want to make sure i created a table in the oracle 8i DB
I need the simple command to show me all the tables in the DB.
I use the system/manager to create the table and it should be there I think.

My DB is on solaris but I think it should...

Hi, I'm a newbie to vbscript and oracle. What I'm trying to achieve is to use vbscript to connect to Oracle database to pull some data out. I've installed the oracle client in my laptop. Below is the code I copied from somewhere but somehow I'm...

Hi experts, I am trying to pass a string to a servlet.  The string is too long and cannot use the get method because of the limitation the get method has.  I need a sample code of utl_http using the post method to pass the string.  I think it has...

Hi,

I am just trying to execute stored procedures that are already built, and i get error messages when i try to execute.

I have several IN parameters that i assign, but my IN OUT parameters i don't have the values for, or i don't think...

Hello Everyone,

Please disregard the version i stated earlier it is in fact Oracle 10.2 that i am using
I'd like to thank everyone  before hand for any assistance provided. I am trying to import a customer database to an already existing one....

Hi there, I have Windows 7 (64bit) ... is there Oracle Client 10g (64bit or 32bit) installers?

I can't seem to find them in Oracle downloads. Any help is much appreaciated. Thanks.

Need to create a schema in oracle and can someone give me syntax

I am attempting to load a tab-delimited file into Oracle (9i) using SQL Loader.  I am using the following control file script (which works flawlessly on the same data if it is comma-delimited):
...

Hi what is the left function in Oracle?  The left function is something I would ordinarily use in MS SQL.  Thanks.  

Greetings experts,

I'm trying to set up a simple bulk update using a record rowtype and a table of that record.  I'm getting errors in the line where I do the fetch saying the SQL statement was ignored and that the table variable is...

Hi,

Trying to create an Oracle Forms logon screen to verify a username and password contained in an Oracle9i table.
I've tested the following code which compiles with no errors but does not verify the username and password when entered.
...

Greetings,

I found the following example on how to load XMl file into Oracle table from the experts  site.
However, when I tried to replicate this example in my environment it didn't work and few errors were identified.
Here is my questions:...

I have a unix shell script (test.sh) that activates sqlplus to run a sql script (test.sql).  The sql script spools the output to test.dat.  I do not want test.dat to contain query that is echoed.  Also, I do not want test.dat to contain a line...

I have both Oracle 8.0.4  and Developer 6i installed on the same machine.
I wanna use Arabic language while entering data through Forms and viewing Reports.
I have found the following values from oracle8i doc:
Language:   Arabic
Territory:   ...

I have two tables ALPHA and BETA. I need to update the BETAID to the ALPHAID. The BETAID is currently set to the ALPHADESC so I am joining on this column.

The following update statement works fine in SQL Server:

UPDATE BETA
SET BETAID=...

is there a function in oracle which serves the same functionality as isnumber() in vb6 i.e to find out whether passed parameter is umber or not

what is the equivalent of getdate() from sql server  in oracle\I am tryingto get the current date

Someone asked this question on 3/8/03 and got an answer that almost works and I was wondering if anyone knew why the first record is always rejected and what the fix is.

The original question;

create table customers(
custID number primary...

Looking for a code example (pl/sql and SQL query ...) to read, update and insert clob column types (external and internal)
with Oracle9i.
I've heard it was simplified in Oracle 9i compare to 8i where empty_clob and pointers (start and end...

While looping through a cursor I need to loop through each column without knowing the column name.  For instance

This works:
LOOP
 FETCH MVAR_cursor into MVAR_record;
 EXIT WHEN MVAR_cursor%NOTFOUND;
    MVAR_record.COLUMNNAME1;
    ...

Hi ,

I have recently donload oracle xe 10g at my home PC.When i run that its giving a problem....
I had noticed a listener problem in log file.It shows up as below...my OS is windows XP

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 -...

I want the results like that

emp  dept  
14   4

instead of
select count(*) from emp;
14
select count(*) from dept;
4


I want one sql statement to find the number of rows in all the tables for a user.

can you help me??

Hi,

(Win Server 2003)
(Oracle 11g)

I need help troubleshooting a problem I have when re-starting the OracleDBConsole
in order to use the OEM again.

It has worked for the past week. then it started to behave erratically, like not...

Hi,

I need to retrieve record from the Oracle database by comparing with a time range? The column "OTime" is of Date datatype. I'm using ASP.

This is my SQL:
"SELECT * FROM Purchase WHERE (OTime BETWEEN to_date('" & from_time & "',...

I have just installed Oracle 11g r2 64bit on Windows server using the local administrator account,  I have also installed the ODAC for visual studios 2010.  Everything seems to be working fine except when I go to connect to the database from a...

( Product : DBMS -> ORACLE, DB2 and SQL Server )
Hi Experts,

I want to know the difference between the functions SYSDATE, CURRENT_DATE, CURRENT_TIMESTAMP in ORACLE, DB2 and SQL Server.?

What does CURRENT_DATE in oracle do ? Is it date...

How to get this to work in oracle:

SELECT LAST(VALUE) AS RESULT FROM RESULTS
WHERE MRC_ID = 5 AND RESULT_DATE < TO_DATE('01/01/2006', 'DD/MM/YYYY')
GROUP BY RESULT_DATE ORDER BY RESULT_DATE DESC

Using MAX(VALUE) is not correct as I need...

Hi all, I have a table that holds log data. It has a date column. What I want to do is to be able to group this data by month (I can do this), but also by year. So I get something like the following

Jan 2006 - 100
Feb 2006 - 120
Mar 2006 -...

HI everyone,

I have a  service written in PRO C that is doing a simple Select from a table.  I have debugged it to make sure that the parameters that are being passed are correct.  I get a return sqlca.sqlcode of 1403 but the when I run the...

I installed Oracle instant client 11.1

I am able to log into database using command prompt. It picks up the correct tnsnames.ora in folder C:\oracle\instantclient_11_1\TNSNAMES.ora

However, when i use an external tool such as TOAD or Pl/Sql...

I'm new to both Oracle and Windows 7 but the organization I've joined recently upgraded Oracle Forms and Oracle Reports (in a series of stages) from 6i to 11g.  Everything has worked fine when the operating system was Windows XP, but on my...

I've installed and uninstalled and keep getting this error.
help appreciated on how to fix this and get up and running.

The installer cannot ping the domain.Verify that Informatica Services is running on the domain host and select Retry.
...

All,

Listed below is my code.  I get the following errors when trying to execute:

EXCEPTION
*
ERROR at line 57:
ORA-06550: line 57, column 10:
PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the
following:
begin...

Symantec endpoint server 11 internal database service not starting
giving below mentioned error :

Problem:
Failed to start this service "symantec embeded database".
Error in event log:
The description for Event ID ( 1 ) in Source ( ASA...

Hi,

I came back with my last question. The view could be created now but without parameters sent as procedure arguments.

I would have liked to see running something like (it's just a simplified form):

CREATE OR REPLACE PROCEDURE sql_test...

Hi, can someone give me the correct syntax for using the SQL imp command in Oracle? I am following several work cases in the newly released book Pro Oracle Spatial. They instruct to execute the following;

imp spatial/spatial file=gc.dmp...

I am trying to make the second tab of a tab canvas appear AFTER the user clicks on a button.

So the default Visible property is set to NO. But when the user clicks the neccissary button to unlock the second tab, it suddenly appears(poof it's...

Hi,

This error has been bugging me for sometime now and I can't find a straight forward answer anywhere, can you help?

Oracle 11g on Windows XP SP2 Intel box.

I am trying to export data and when I'm asked for the Host Credentials I get...

We have someone outside our network trying to make a connection to our oracle database
He gets the "ORA-12569: TNS:packet checksum failure" error message.
Any idea what could be causing this error?

A google search gave me this result......

folks

how do i convert the datepart function in sql server to oracle

i.e

SELECT datepart(year, SYSDATE)
, datepart(month,SYSDATE)


all help will do

r

I'm trying to import a copy (DMP file) of the Millennium schema from the A0218174 into the Oracle database on my Laptop, but I'm confused about how to use the TOUSER parameter.
 
I'm looking at the documentation for the Oracle command line...

Using Oracle 9i, what is the most efficient way of executing the following SELECT and UPDATE statements?

select c.claim_id, c.account_structure_id
from s_dis_claim c
where c.claim_id in ( ...

I found a step by step tutorial online on installing Cognos in Oracle environment posted below:

https://docs.google.com/fileview?id=0B8YywOe-ydiUYmM2MTYzY2UtNmUxMS00ZGVhLWFmNjUtNmZkMTAzMDkyN2Vj&hl=en&pli=1

My progress and environment:
...

DECLARE
            
   -- source table cursor (only columns to be updated)
   -- new data
   CURSOR C1
   IS
      SELECT  O.TXNDATE
        FROM FO_TRXN_STAGE_sTG g, TEST o
       WHERE g.TRXN_INTRL_ID = o.TXNID
       AND  G.trxn_type1_cd...

JVM is crashing once in a week or two. Sometimes only once in a month. Last couple of months the problem is occurring more frequently . The memory profiles seems to be fine. I ran pmat tool from IBM on the garbage collection data and it did not...

I just install the database from the scratch and select the most common installation instructions. It creates a database by default. Now I make a user and import data into just one table from a .csv files using sql* loader. All goes well.This...

In the line

StrDate DATE DEFAULT SYSDATE;

I would like to have a DEFAULT SYSDATE format  : 'DD-MON-YYYY HH24:MI:SS' ... only for this particular field .. the others have the format 'DD-MON-YYYY'

I would like to avoid to use ALTER SESSION...

I recently upgraded our server to Oracle 11g R2 64 bit, so I read that the client machine should be the same version, so I installed Instantclient from Oracle on a 32 bit Windows 2003 machine. I unzipped the file into a folder called...

How can I list all tables in a schema?  I would like to build a reporting tool, which I can run and it will list all tables in a schema.  It would have to be done via a query (odbc).


In the future, I would like to convert it to a Stored...

Hi,

I've recently installed Oracle10g and I'm testing some of our App DBA scripts but I'm running into "Insufficient Privileges" errors.  In Oracle8i and 9i, I granted our schema owner the following privs:

grant connect to schema_owner;...

I am receiving this error in my alert log:

ORA-01264: Unable to create archived log file name
ORA-01262: Stat failed on a file destination directory
SVR4 Error: 2: No such file or directory
Error with archive destination...

Hi
   Could someone explain the difference between Oracle datatypes, Number and Integer. Under what circumstances should I use them ?

Any help is greatly appreciated.

Thanx

Dylan

Hi, I'm a complete Oracle newbie. But I've got an instance of Oracle 9i running that I need to run an sql script on (see script below) to get the database ready for an update to WebCT (a course management system) .  The sql file is a little sql...

Export file created by EXPORT:V08.01.07 via conventional path
import done in US7ASCII character set and US7ASCII NCHAR character set
. importing V500's objects into V500
. . importing table                      "ADDRESS"
IMP-00058: ORACLE...

I have access to an oracle DBA account but I am unable to revalidate Oracle invalid synonyms.
I do not have access to SYS or SYSTEM accounts.

Any ideas how I can do this without access to the two oracle accounts?

I know I can revalidate...

Hi ,

Is there a way in oracle (e.g through a system table) to see whether there is a certain partition in a table?

thanks

I wrote following script,

select a.address
,      s.status
,      s.username
,      s.osuser
,      a.sql_text
from v$sql a,    v$session s
where s.sql_address = a.address;

Questions:
1.   Is the join alright? Which is better for...

Hey guys,
  I have a date stored in a column in Oracle in DATE format.  When I look at the data through a select statement it returns

mm/dd/yyyy hh:mm:ss am(pm)

I'm a SQL Server guy and need a select statement that would ruturn data from...

Input:
  3 Servers, all with Oracle 9.2
  * PROD    --- live production server
  * STANDBY  --- standby database, updated every night by applying the logs, the rest of the day it is open as read_only
  * DW   --- a database that reports...

Hi!

I am new to Oracle installations, starting with this job last month and learning. I have successfully installed the application database on one machine, the Oracle Identity Management (OIM) and the Oracle Application Server (OAS) on a...

ORACLE 10 G

Hi

 I have created a strored procedure and it compiles fine but Im not able to see any results so therfore it must not be executing.  Ive done a very basic one to test but its not working so Im looking for some help please
...