Oracle
in [SQL]
|
restore datafile Hi, Try to restore some datafiles of an instance in order to create another database. Need this to restore a single table. However the restore fails: it tells me that the datafile is in use or in recovery. Looks it tries to recover the actual instance but that's not what I want. Just need the datafiles. This is ... 1 Jul 2008 16:27
Protect record from deletion via trigger Hi all, I have a question regarding delete triggers. is there a way to protect one specific record of a table from deletion? The way to do it with a view and instead triggers is not possible. Also i can't raise an APPLICATION_ERROR, since the whole thing should not be visible from application side. Is there a wa... 2 Jul 2008 12:55
ORA-27086: skgfglk: unable to lock file - already in use -> Instance "BOCHUM", status BLOCKED "Mladen Gogala" <mgogala(a)yahoo.com> schreef in bericht news:4869ea21$0$1350$834e42db(a)reader.greatnowhere.com... On Fri, 27 Jun 2008 02:36:36 -0700, A. Farber wrote: Hello DBAs, I'm running Oracle 9.2.0.8 on CentOS Linux 4.6 (which is same as RHEL 4.6). This is an unsupported version of i... 1 Jul 2008 06:10
What are ORA$AT_OS_OPT_SY_665 like 11g jobs? Hi. I'm having a problem with oracle 11g: Once in a while system runs jobs named something like in a title. Those are very resource intensive and in my case last for 4-5 minutes. During this time my application using this db keeps getting errors on trying to connect to a database or create a transaction. Can a... 4 Jul 2008 08:58
3 X 18 GB disks Hello, I got some guidance earlier (TA!) about what possibilities their were for slicig and dicing 3 X18 GB disks on a Sun 440 development box for Oracle 10G. So now current plan is to put Solaris 10 and query app on disk1, oracle product on a 5G B slice /u01 on disk2 and data on disk3 / u02. I know the data is... 2 Jul 2008 12:55
Tuning tool Hi all, I am using 10g. I want to test a few queries and have a look at the execution plan. But I cannot find where is the tool. The tuning tool seems only applicable to the most used queries in the database, but not any one. ... 3 Jul 2008 13:32
how to recover the DB from a dmp file? Hi all, we had corrupted one datafile and now the DB could not be open, but can be mount. Unfortunately, we are running our DB in NOARCHIVE mode and we don't have a backup too. We have a full dmp file only. STARTUP FORCE ORACLE instance started. Total System Global Area 27480224 bytes Fixed Size ... 1 Jul 2008 14:23
ORA-00959: tablespace '_$deleted$8$0' does not exist Hi, we're carrying out some data conversions, and do get a mysterious "INSERT INTO xxx_yyyyyyy ORA-00959: tablespace '_$deleted$8$0' does not exist" Things should be easy; just an ordinary tablespace with a normal table .... 10.2.0.1; linux. Any ideas ??; BR; Timo ... 30 Jun 2008 08:36
User-managed incomplete recovery in noarchivelog mode Hi all, I have two full sets of close database files backup. One on 28 June and another on 29 June. Today, 30 June, I need to restore the whole database by using the backup files on 29 June. But I found that one of the data files, user01.dbf, was corrupted. Since the database is running in noarchivelog mo... 30 Jun 2008 16:51
Best way to delete million records Hi all, I have to delete about 43 millions rows from a table, but the following conditions exist: - The table is not partitioned and unfortunately I can't modify the structure - The delete procedure must be done without stopping service, so I can't use CTAS, moving records and renaming table. - I can't us... 30 Jun 2008 16:51 |