I am string to insert dates in this format :2005-08-19
I tried to do : insert into foo (foodate) values('2005-08-19');
foo date is an Oracle date type field.
I get [ORA-01861: literal does not match format string]

Can i delete the trace files (not the altert log ) in the bdump folder
when the db is running.
I tried this out in the test systems and i did not have any problems.
But would like to take advice before doing this on the Production

Using Oracle 10gWhen attempting to create PFILE FROM SPFILE I get the
following error
CREATE PFILE= 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\ORACLE11.ORA' FROM
SPFILE= C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA';

IBM sets DB2 database free
IBM on Monday introduced a free version of its DB2 database, a move designed
to win software developers over to its products.
DB2 Express-C is the same database as IBM's commercial offerings but the

I'm trying to use a custom function in a query I want to use.  The
custom function I've written takes two numeric arguments, and return a
number of 0 or 1, which I want to use to sort data with.
However, I wish to use the distinct keyword in my SQL, which is giving

I am getting the following error:
ORA-01089: immediate shutdown in progress - no operations are permitted
I ran 'shutdown immediate'. then it kind of stuck there for long time
and i had to kill the session as usually it is very fast. Ay ideas

I have two tables
The first one is tblItemDB has two columns (ItemID, ComponentID)
The second one is tblItemInfo has three columns (ItemID, MerchanNumber,
Type)

Right I am trying to load some data using sqlldr into Oracle 9.
I have a table that contains a varray, which is declared thus:
type CONS_PERIOD_VALUES as VARRAY (50) of NUMBER(13,5)
Now the thing is that I want the varray to be 'padded out' with nulls

We're observing a pretty weird behavior with Oracle 9.2.0.1 and 10g,
though, maybe it is considered normal for these products, I don't know.
The synopsis is the following:
1. Oracle (9.2 and 10g) is installed on Windows Server 2003 with all

Our admin is hesitant to put a Solaris 9 box up on the network w/o
having AS10g installed and hardened first.  I installed AS10g and
specified the FQDN each time it asked for a hostname, although the
machine does not have one, yet.

Can anyone explain how "alter table x move tablespace y" ended up using
more space in table x than was the case before the move.
I'm looking in dba_segments to see how much space is used.
The reason I'm doing the move is to free up some space but for a

I am planning to increase my hw with a new server. For some reasons i
am planning to chose the HP platform but i have some doubts between
PA-RISC and Itanium.
HP recommends Itanium for better perfomance but Oracle software patches

I wanted to know the equivalent for the following Oracle queries in SQL
Server perferably if I can get the data directly from a system table
like in Oracle
1. As part of this select we need the following to be returned

Hi  guys,
When we execute a select stmt in sqlplus we don't get the  column
headings full , it is shown according to the data in that column.
So, i want to display the column headings in full as it was mentioned ,

I have encountered a weird problem last week and been dealing with it
since. I have a query that is accessing several tables in remote
Teradata databases using Oracle OpenGateway( formerly known as
Transparent GW). The problem is that the same query is finishing either