Dear Experts,
Problem: An Active Server Page on a Windows2000 Server (IIS5.0) returns "???" from ODBC connection to a UNIX 9i database instead of the proper characters.
Background: I...
The only way to recover is from media backup? I know I cannot "rebuild" system datafile, but if I don't have a backup - I know shame on me!!! - Is there anyway to recover database????
I'm GETTING ORA-01031 ON EXECUTE IMMEDIATe while executing proc.
I have a privelge to create table, which privileges need to be granted to my account to execute this command successfully?
I'm experiencing this error in a PL/SQL routine that has not changed (for months) and that makes no rowid or "where current of" manipulations. The statement that fails is an update of one tabl...
Hi Experts.
I have a problem with a 9i database on win2k svr , I cant start the listener for OEM
LSNRCTL> start oem
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Versi...
I want the output to be left justified so I enter
column columnname format a9 justify left
but it does not work... Can you tell me what am I doing wrong? check the session.
---------...
I have the following select
select count(*)
from SLOG, BRPS
where SLOG.task like 'QPRO%'
and SLOG.bpdate = BRPS.PREVBRANPRCDATE
and SLOG.BR = BRPS.BR ;
Now, I want to dele...
I have created a user for the developers on the database server to run processes to import into the database.
However, when they try to run sqlplus the hit error message.
I know it is caused...
What is the difference between them, can i include procedure and function with in package?
How can i execute package, like i used to execute procedure by execute Procedure_name;
Please exp...
Oracle 10g on Windows 2003 server
The Oracle Listener just went down and I cannot start it back up.
When I try starting the LISTENER from services.msc I get:
Error 1067: The process ter...
Maybe it's not a difficult question:
How to perform a full export and then after make a full import of an Oracle 9i? I need to do it with system user.
Make a dmp file of all schemas of the d...
Hi there
My background is in SQL Server, I decided to learn dba tasks about Oracle.
Having problems similarly with Install plus creating a database and managing a database created.
If...
The performance has been downgraded after the DB migration... The Query seems running slower than it used to be,
How can I update statistics / find missing index to fix it in Oracle?
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 directory
i got this error when running sqlplus.. does...
1) We have a Oracle 10g r1 database server on windows 2000 server.
2) This is a existing parameter and its value:
NLS_CHARACTERSET WE8MSWIN1252
3) We need to change as fol...
I'm trying to use bind variables in some stored procedures I'm writing in Oracle 10g (sqlplus version 9.2.0.1.0). For example:
sqlplus>variable v NUMBER;
sqlplus>begin
2 :v=10;
3 end;
4 /...
I'd like to know how to: in sql plus
1. display table name,datatype of fields of a table
2. copy a table structure
hi,
I am using mssql with oledb,
I have this sql text like:
;===========================================
IF (select count(*) from table_user where userid=1700))=0
INSERT INTO table_user...
I read article from the following URL but don't know why I cannot use the DATEPART function.
http://www.databasejournal.com/features/mssql/article.php/10894_2209321_2
I am using ORACLE S...
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...
Hello I'd like to move a database from one oracle DBMS to another (from 8.1.7 to 9.0.2)
I'm using exp/imp that is working fine though during the import I get the ora-1401 error because on t...
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 a...
I have a DB (Oracle 9i) which has recently been growing at an exponential rate. We finally found the source of the problem and have run the appropriate scripts to clear out the garbage data b...
I've got a table with 10 columns,
first I have checkboxes (char(1)-columns) A, B, C, D and E.
For each of these I have a date containing the timestamp when each of
the other columns are...
I have a procedure that I have written that works. Unfortunately some of the data that it returns is 'Null' and hence the corresponding update fails. I want to write exception handling that wi...
