Oracle
in [SQL]
|
Oracle error of "recover database until scn..." Hi all, I get error message when using "recover database until scn ...." as below: ------------------------------------------------------------------------------ RMAN> list backup; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -... 15 Jul 2008 21:36
execute the queries that do the record count in sqlplus I have a script test1.sql that has the queries that do the record count in the tables. When I run the script in SQLPLUS using @C:\test1.sql, I only got the result, but I want to print the queries too so that I know which queries corresponding to which result. Any ideas how? thanks!! test1.sql ----------------... 12 Jul 2008 13:34
Raw devices /dev/raw missing after reboot? I'm running Oracle Linux and I'm trying to create raw devices from our EMC San. I added entries to /etc/sysconfig/rawdevices after fdisking the emcpowerx luns: /dev/raw/raw1 /dev/emcpowera1 ... etc... I don't know why there is no /dev/raw folder or any rawx subfolders. I did see a command called 'MAKEDEV ra... 13 Jul 2008 18:12
Best chip for Oracle AMD, INTEL, SPARC I know you are going to say that it all depends on the O/S, but if you can forget that for the minute, does it matter what the CPU is when your are compare the Intel Xeon Quads, AMD Quads and Sun SPARC chips. Does the cache make a big difference, since you think then SPARC / INTEL would be best and you would ne... 14 Jul 2008 13:41
silent deinstall of 8.1.7 Hello: I am trying to uninstall the 8.1.7 client from about 200 workstation using an rsp file. AFter the prerequisites apss, I am presented with qan inventory selectiono scree, or, if running with the -silent switch, I get an error message that no product has been selected for deinstallation. The log is shown ... 11 Jul 2008 09:55
Select max within max Hi all, 10.2.x on Linux ... Is there a "neater"/more efficient way of selecting the maximum value for a column based on the maximum value of another column. Gods that reads poorly, I'll try an example ... SomeTable ColX ColY ColZ .... MoreCols A 1 8 .... A 1 9 .... A ... 13 Jul 2008 06:55
Is 11g ready for Production....? We are considering upgrading our Enterprise Edition database from 10gR2 to 11g. My instinct tells me that its a bad idea to upgrade to the first release of a major version. I've been burnt in the past by upgrading to 9iR1 and 10gR1 (both of which I thought were useless). 11g has been out for a while now, is 1... 14 Jul 2008 09:33
Oracle 10 admin question How to get the DB activity report (like sar in UNIX), like number of queries, history of queries, % utilization of SGA_TARGET, % utilization of CPU, %IO, etc from within Oracle 10. Can the info be obtained via sql queries against Oracle admin views? I don't have access to OEM. Please advise. Thanks. ... 14 Jul 2008 15:45
populating a date field with random dates I have a table that is populated with data for the month of June, I need to add roughly an equal number of rows to the table, but with the dates in the month of May. I can do an insert into table_a select field1,field2..date_field-30..field6 from table_a and that works ok, but I'd sooner be able to copy all ... 10 Jul 2008 18:35
Help: Ungrading OS Dear group, Currently we have Oracle 10.2.0.3 on RedHat linux AS 3.0, we need to upgrade our RedHat linux from 3.0 to 4.0. Will this OS upgrade cause any problem to our DB, software? Do I need to re-install our software? Will my datafile affected any by this upgrade? This is very important system, I need ... 10 Jul 2008 18:35 |