I installed dbi and dbdoracle via blastwave and recieve the following error
install_driver(Oracle) failed: Can't load '/opt/csw/lib/perl/csw/auto/DBD/Oracle/Oracle.so' for module DBD::Oracl...
What is the best way to clone database in Oracle 9i window sever to Oracle 10g window server(new server)? Use DBCA(database creation assiatant? or from DOS command line? I have 15 tablespaces ...
How can i pass a runtime parameter in to SQL query through shell script? if so how . here is my sql query attached.
Hi Experts,
Clients wants me to refresh the PROD DB from standby database. Standby database is in Recovery Managed Mode.
So can I take any Backup(RMAN, Exp/Imp, Cold/Hot) of Standby database...
Hi Experts,
I want to look for deadlook error in the alert log file?
I need to knwo how to trace it and how we will find the trace file for that?
Scenario
In my oracle database 2 tables T1 and T2 in the same structure. Data in the table T1 is inserted from an external application, which I don't have any control. I want to copy the data...
Hi
We are running Oracle 9 on AIX. We have a primary database running on one machine and a standby on another. I am in the process of creating a second standby on the same machine (as...
We are correcting several Actuate reports for the ICM Application.
For one of the reports we have a select query imbeded in the Actuate report.
We run this query against the oracle 9i da...
I have a ts named I_OMF, and it is growing so fast. How do you figure out the daily growth rate in MB for past 30 days?
Is there a script to figure that out?
thx much
How can I check which object is relaying on a function or procedure ?
Cheers,
Andrew
I have a form that allows DELETE to records. But for some user , I do not allow SHIFT-F6 , which is a DELETE, to be pressed.
I can I check to see if SHIFT-F6 has been pressed by the user?
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
System: Microsoft Windows Serv...
I want to start collecting snapshots using the statspack.snap package, but I don't know how much will increase my DB per snapshot?, and if so, Where can I monitore the space used by it?, I've ...
Dear experts,
I am trying to loop through some records of a dynamic peice of SQL. I have created a procedure based on an example I found that compiles ok. (see first peice of pl/sql)
Wha...
I am upgrading an existing Oracle 9i server to a new server running Oracle 10g. I exported the data and created the new databases on the 10g server, but I now need to create the users and tab...
WhI've exported a schema and i want to verify the export file is good.
What is the parameter i give to oracle to say just verify this .dmp file?
Running 9i on Solaris
does anybody know how I can run dbms_utility.analyze_schema and exempt a few my larger and less used tables?
I was using the ANALYZE TABLE command but I was told dbms_utility.analyze_schema ...
I need to create a new user to an existing db, schema name is 'EST'
HOW CAN I CREATE A NEW USER WITH READ ONLY PRIVILAGE ON 'EST'?
Hi I'm trying to import a table from one database that has a an extra column third from the bottom ot table. The table I'd like to import it to does not have this column this a test database. ...
hi
This is the error i get when i load from flat file into table in oracle 9i using sql loader in toad.
Record 1: Rejected - Error on table "RET****", column EC_RE_DATE.
ORA-01847: day o...
I am viewing reports (crystal) from my web application built using java , jsp and struts with SQL Server as database but when i changed my database to Oracle 9i then i get the following except...
Dear Experts,
Thanks for your continued support , this time
I need to install Oracle 9.2.0.8 on SOLARIS 9 , i guess SOLARIS 9 and 5.9 means the same? from this you might have got a picture o...
Hi,
I've a sql query that goes very fast but when I add a sort order (ascending or descending) at the end of the query it's very slooooooow
Can anyone tell me how I've to solve this pr...
Hello!
I have a server which runs Oracle 9i with alot of data in a database. I want to install Oracle 10g in another server (and I installed), then I want to get a full dump (backup) from O...
Looking for a SQL script that will report back on the objects in a particular tablespace and their respective size and percentage of the total tablespace size.
Reason for this is we have a ...
