What can you experts say about performance in Oracle on a table without primary key. Assume this:
Table1 has c_id (PK), value.
Table2 has c_id (FK), from_date, to_date, value.
What are th...
I have two database or service name installed on the same server.
How do I shutdown and startup the database for just one service name without affecting the other one?
This is Oracle 9i ...
i have 10g database iam exporting some database iam running a export command but we are getting
the err exp-0091 this script was working fine we were using it previously ..
thanks
while rendering a report in SSRS 2005 , I get the exception of type 'System.OutOfMemoryException'.But when I Execute the procedure in the database, the records are displayed without any error....
I am using ORACLE 9i. What is the proper syntax of writing a STORED PROCEDURE in ORACLE 9i with some examples and how can I access that PROCEDURES through my application written in C#.NET?
Hello,
I have to use spool to export data to flat file(.txt) in oracle. These columns available in my table (TBL_JE_OUTPUT )
RECORD_TYPE,BUSINESSUNIT, JOURNALID,LEDGER,JOURNAL_LINE_NO, ACC...
Hello,
We are using Oracle 9i on windows 2003 system. Server is of Dell make SC430 model (with 1 GB RAM) We have various oracle databases working simultaniously. Last few days it is observ...
Windows 2003 Server, SP 1
Oracle Enterprise Edition 9.2.0.8
Our database client population is growing, today we reached 350 concurrent connected
sessions.
Users started complaining stat...
I tried to create this materialized view:
CREATE MATERIALIZED VIEW mv_cost_est
BUILD IMMEDIATE
REFRESH complete
START WITH to_date(sysdate,'dd/mm/yyyy hh24:mi:ss')
NEXT sysdate + 60/86...
I want to take all the data in the cells from an EXCEL spreadsheet and populate an ORACLE table.
Can this be done, and if YES, then where do I start?
folks
how do i show
DECODE(TO_CHAR(due,'iw'),TO_CHAR(ADD_weeks(SYSDATE, 1), 'iw'),'X') week1
and
DECODE(TO_CHAR(workorder.targstartdate,'iw'),TO_CHAR(ADD_weeks(SYSDATE, 1), 'iw')...
Hi,
Can someone give me a quick rundown on materialised views, for example what are they and how do they behave and maybe a couple of examples on where and why they would be used? I'm new t...
I received the following errors on my alert log
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF781600B8], [], [], [], [], [], []
Whe...
Hi,
I'm running an Oracle 9.2.0.6 database on a windows 2003 Cluster with FailSafe. I've got an Export job that runs every night but fails to reach status 'complete'. I can check at the file ...
Hi,
I need to return 10 items from a SELECT statement. This is part of a large piece of SQL so I put this part into a function. What I'm trying to determine is which is the best tp use this ...
Will someone please give me the command to show how many records are in a table called ISOFT.NOTICE in tablespace ISOFT_TABLES?
I have an Oracle database running on a HP Proliant DL380 G3 server. I want to replace the my 72GB drives in my raid 3 with some larger drivers. Taking into consideration that this has to done ...
Can someone explain to me what is that first part of TNS entry "MCPP.ABC.DEF.ORG".
I thought it is only a label and it will actually use whatever the service name defined in
SERVICE_NAME wh...
Hi all,
I am going to migrate Oracle database from Oracle 8i to oracle 9i.
Issues:
1.I want to keep oracle 8i installtion as it is. so the structure is in drive D:\oracle\ora81, D:\oracle\...
I'm using Oracle 9i ODBC Connection with PowerBuilder 10.0.1.6064. When I'm querying thru DB Profile and Datawindow, its showing Junk for Arabic Data.
I have already done the Reginal Setting...
During server reinstall process we had to use exp/imp Oracle utils to backup/restore data.
For some strange reason our new database now works slower than old one. I have compared internal str...
Hi All,
I would like to create a BEFORE DELETE trigger that does not delete the record but just tagged it as INACTIVE.
I am thinking if a CANCEL DELETE like statement exists in Oracle PL...
Hi All,
What is the Oracle query equivalent to the below MS SQL query?
SELECT name FROM syscolumns
WHERE (id = (SELECT id FROM sysobjects WHERE name = [TableName])
ORDER BY colorder
...
Hai Experts.
my manager would like to know the history of deleted and commited records for the last 2 years.
i ran following scripts in sys user unfortunately i'm able to get last two days ...
Hi all,
I have to develop a website with audio streaming. I have to fetch the audio file from Oracle DB. I have to play it webcast it live. I'm not sure whether i have to use streaming server...
