Hi Suman
I want to call C Program routine from PL/SQL. What all things I need
to do.
ExtProc's are what you need. Check out the very good tutorial at:
http://home.clara.net/dwotton/dba/oracle_extn_rtn.htm
Regards
Dale
-
DataBee: Software that creates small referentially correct
Hi, All,
Is there any way to find out the parameters setting in session level? These
parameters are not the initialization parameters.
For example, if alter session set use_stored_outlines=true; how could I find out the
use_stored_outlines value later on?
TIA
Unless otherwise stated,
could anyone of u
tell me a good mailing lists for Visual Basic/Delphi ??
Thanks and regards,Santosh
resending the mail. Kindly ignore my prev mail with wrong subject.
Hi All,
I ve a stored proceure and with the following cursor defined. And after
running the procedure, i see that No of open cursors incresing. I checked
it querying v$open_cursor like this. ( SELECT sql_text from
How about removing the skip3
jack
Fink, Dan
Hi All,
I ve a stored proceure and with the following cursor defined. And after
running the procedure, i see that No of open cursors incresing. I checked
it querying v$open_cursor like this. ( SELECT sql_text from v$open_cursor).
CURSOR all_rules (l_ticket_type_id NUMBER) IS
SELECT
Chuan:
You can not get these SESSION ALTERED values from any
of the X$views or from external sessions. You will have
to do a PGA dump to get these values. It is technically
possible by burning your time in PGA Dump.
KG
-Original Message-
Sent: Wednesday, September 18, 2002 12:33 AM
hi all
how to define a number(10) oracle datatype in microfocus cobol.
when we code it as pic s9(10) comp-5 we get an error message
PCC-0026 Undeclared host variable name at line num in file name
with a number(5) datatype and a cobol definition pic s9(5) comp-5 we don't
get the error
A cursor for-loop is a open-fetch-close construct, but
like all cursors on PL/SQL, Oracle does not *really*
close them when it encounters the close call. This is
an efficiency measure to speed things up in the hope
that you will reuse them.
hth
connor
--- JOSHY MON M C [EMAIL PROTECTED]
Hello Ramon
I think that you have an error in your
parameters.
As far as I know (not much) the second network card have a
different TCP/IP address.
You have to put this address in the added line in
listener.ora and add (load_balance=on).
(ADDRESS_LIST
=
(load_balance=on) (ADDRESS =
Hi Dale,
Thanks a lot.. It is too good.
Regards
Suman
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 12:43 PM
To: Multiple recipients of list ORACLE-L
Dan,
I think set recsep off might do the trick as because that particular record
wraps (because of the chr(10)) it inserts the blank line as default
behaviour.
This would cause you to lose the desired blank lines between the other
records though unless you added an extra chr(10) at the end.
Hi Everybody,
I have created two Package
Pkg1 and Pkg2
Inside Pkg1, I have defined PL/SQL Table Data Type
Type Pkg1_DataType IS TABLE OF VARCHAR2(10)
INDEX BY BINARY_INTEGER;
Inside Pkg2, I have defined Type
Type Pkg2_DataType
Hi all,
Can anyone share any experience of the logging option on Solaris 8
filesystems with regard to Oracle and performance. I've just inhereted a
second hand Sun box to use as a test machine and the filesystems are
already set up with this option for both redo log disks and datafile disks.
hi everyone
anyone where the sys view X_$KGLCURSOR is being created ? I have several X_$
views on that particular scheme.
strange is that these views not appear on all servers, so i don't think
these are created via catalog or catproc procedures.
this is a oracle 8.1.7.0. install on a windows
Kor, Geo wil graag bericht X_$KGLCURSOR view intrekken.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Bill:
In theory I don;t see any reason for not using UFS logging
in file systems. But as far as the performance goes, you
will see a slight decrease since the system has to do more
work than the normal logging. But your recovery will be
very fast after the crash since 'fsck' will be completed
yes,
as UNIX sysadmin, I can say this
The logging parameters is insteresting when you put it as parameter inside
/etc/vfstab
What says the manual (RTFM :-;)
logging | nologging
If logging is specified, then logging is
enabled
Hi
Isn't that part of the Steve Adams scripts prerequisites?
www.ixora.com.au
Jack
[EMAIL PROTECTED]
yes, i came to the same conclusion as you did.
i tried to withdraw my posting but it was too late.
it was the script create_xviews
thanks
-Oorspronkelijk bericht-
Van: Jack van Zanen [SMTP:[EMAIL PROTECTED]]
Verzonden:woensdag 18 september 2002 13:43
Aan: Multiple recipients
On Tue, Sep 17, 2002 at 09:03:18PM -0800, Rahul wrote:
why not just simplay *name* it !!!
SQL alter database backup controlfile to '/oracle/ctrl.trc';
This is what I've been doing in my backup set, but I wanted to
add the flat version as a backup to the backup. I never would
have thought
What about:
sqlplus -s EOF logfile
/ as sysdba
oradebug setmypid
alter database backup controlfile to trace;
oradebug tracefile_name
exit
EOF
your_file=`tail -1 logfile`
echo $your_file
Regards,
Waleed
-Original Message-
Sent: Tuesday, September 17, 2002 6:28 PM
To: Multiple
Thanks to all who replied. I got a lot of hints from
all.
The problem I had was because I was not separately
backuping up the control files. I was relying on the
control files backup included in the full database
backups. These control files do not have details about
the current backup. So when
Title: Tracking Temp Segment Usage and Event 10046
I'd
start looking at the execution plans first and examine if there is any Cartesian
joins and the order the tables get joined.
Waleed
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Tuesday,
If you just want a numeric field of 10 positions
fieldpic 9(10). -- 10 numeric positions 0123456789
fieldpic 9(10)V99 -- 10 numeric positions plus 2 decimals
0123456789.12
in your definition
s means sign field
comp-5 means a compressed field.
luck
Ramon
What about:
sqlplus -s EOF logfile
/ as sysdba
oradebug setmypid
alter database backup controlfile to trace;
oradebug tracefile_name
exit
EOF
your_file=`tail -1 logfile`
echo $your_file
Regards,
Waleed
-Original Message-
Sent: Tuesday, September 17, 2002 6:28 PM
To: Multiple
TKS Yechiel for your help,
Two more questions.
Is there any way I can find out which one of the 2 addresses I
am using ?
Which isbetter solution this method or add another
listener ?
Tks for your help
TIA
Ramon
- Original Message -
From:
Yechiel
Adar
To: Multiple
What about:
sqlplus -s EOF logfile
/ as sysdba
oradebug setmypid
alter database backup controlfile to trace;
oradebug tracefile_name
exit
EOF
your_file=`tail -1 logfile`
echo $your_file
Regards,
Waleed
-Original Message-
Sent: Tuesday, September 17, 2002 6:28 PM
To: Multiple
Bingo! I turned recsep off and it did the trick. Thanks!
-Original Message-
Sent: Wednesday, September 18, 2002 2:37 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Dan,
I think set recsep off might do the trick as because that particular record
wraps (because of the chr(10)) it
Dan,
It's the chr(10).
SQL select ename||chr(10)||to_char(empno) title
2 from emp
3* where rownum 3
TITLE
---
SMITH
7369
ALLEN
7499
SQL set recsep off
SQL /
TITLE
---
SMITH
7369
ALLEN
7499
Yes, you can certainly do that -- I was just disappointed that the script
would have to be a shell script instead of just a sql script.
I usually do it without creating an intermediate logfile at all by using
ksh's bidirectional pipe feature.
- Original Message -
To: Multiple recipients
Title: HELP! CAN't STARTUP REMOTE DATABASE USING SQL*PLUS - BUG?-NADA on METASTINK
Guys
Trying to automate rman cold backups using sql*plus versus svrmgrl. RMAN is local and target databases are remote.
Executing the following (just from a script seems to work just fine interactively):
Thank you for all the help.
I agree that something is wrong and I will keep looking for it when new fires, with
higher priorities, are put out.
This morning another problem occurred (luckily!!!) on that server, and the server was
re-booted. So far CPU usage oscillates between 1% and 50%,
aren't Cartesian joins are unlikely since all was well in the RBO world?
sounds to me like the RBO was simply selecting better query plans than the
CBO is.
Raj - have you tried playing around with the OPTIMIZER_MODE parameter or
OPTIMIZER_INDEX_CACHING; and OPTIMIZER_INDEX_COST_ADJ as described
I did
not know about the LOAD_BALANCE=ON . Thanks.
-Original Message-From: Ramon E. Estevez
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 18,
2002 10:33 AMTo: Multiple recipients of list
ORACLE-LSubject: Re: Listener load balance
TKS Yechiel for your help,
Two
I doubt the _counter_corriolis_effect parameter would do much:
http://www.ems.psu.edu/~fraser/Bad/BadCoriolis.html
:)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From:
I do not know if you can know which connection the
user use.
However, these changes apply only to the initial
connection.
After the user connect he gets a new port number that
connect
directly to his thread, so I would not worry about the
load
on the listener.
You can use a different
And somebody knows the expected date for the release 9203?
thanks.
-- [EMAIL PROTECTED] wrote
Date: Tue, 17 Sep 2002 12:25:14 -0400
Subject: RE: bug number 2429929
This will be fixed in 9203, I learned this AM, dev rejected our request for
exception patch.
--
Please see the official
Johnson - Congratulations on solving your problem and thank you for sharing
the solution with the rest of us that are in the same boat. When you say you
are taking a backup of the control files after the regular backup, are you
backing the control files up with RMAN or with the system command?
are
either of you or any one on this list working with 11i applications? I am
curious as to how the load balancing works against the hard
coding
of web service infomation in the FND profile options which seems to only
provide configurationfor one application tier.Does
the
second
tier only
Has anyone installed MS SP1 on XP Prof?
If so, have you run into any problems?
Thanks,
Ken Janusz, CPIM
Title: Tracking Temp Segment Usage and Event 10046
I spent last two days working on that SQR and finally nailed it.
Developers were using DISTINCT as a rule and CBO was choosing incorrect indexes.
I had to do following to make it work ...
1.we put hints in appropriate places
2.created 3
Hi Every
one
I have been
struggling with installing net8i client with the development tools viz. reports
builder "Report Builder 6.0.5.28.0", and forms builder "Forms [32 Bit] Version
6.0.5.0.2 (Production)". I use PLSQL Developer from all round automation as an
aid to development. Their
We have a canned package that we use to insert approx 100 records/second
into one table (oltp environment).
Each record is just under 1K (datatypes = number and varchar).
There are several indexes that are build on the table as the records are
inserted.
Each and every record is committed.
I always backup the control file separately (using Rman) as my final step
during a database backup.
Actually, by database backup includes (in order)
Database Backup
Archivelog Backup
Control file Backup.
3 Rman steps.
My Archivelog backup only backs the archivelogs - not the control file.
I am trying to run utlbstat and utlestat for the first time. The output is
not formatted very well. Does anyone
have a cleaner version?
R. Smith
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
Fat City Network Services--
Such a drag to detract from a good story using facts...
...which is how the whole discussion got started...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 18, 2002 9:18 AM
I doubt the _counter_corriolis_effect parameter
If you want to do this method without a log file...
your_file=$( sqlplus -s EOF | tail -1
/ as sysdba
oradebug setmypid
alter database backup controlfile to trace;
oradebug tracefile_name
exit
EOF )
echo $your_file
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system
v$sort_usage and v$sort_segment are always a good
start
hth
connor
--- Khedr, Waleed [EMAIL PROTECTED] wrote:
I'd start looking at the execution plans first and
examine if there is any
Cartesian joins and the order the tables get joined.
Waleed
-Original Message-
Sent:
Ron - First guess: You are executing it from SQL*Plus. Run it under svrmgrl
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, September 18, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L
I am trying to run
LOAD_BALANCE=ON in TNS descriptor means that the
client will try to randomly connect to any
of the
dress descriptions in the descriptor, thus evenly spreading the load. On the
other hand, you can have
a
listener based balancing, which is facilitated through the "local_listener"
init.ora
All I'm saying is that the parameter wouldn't have nearly as much effect as
the _centripedal_acceleration parameter, which as we all know keeps the bits
from flying off of HDs, especially the 15K spin. I believe it's
undocumented now, since setting it to false caused corruption from bit
loss.
My guess is that to start up or shut down a database remotely, you have to
use connect user/password as sysdba;
You will probably need a password file.
See Note 1029539.6 on Metalink which describes how to create password file.
HTH,
Gerardo
-Original Message-
Sent: Wednesday,
I did
it this morning.
No
problems, in fact XP seems to be running faster somehow.
I am
still running out of memory and disk space though, but that's not an OS problem,
it's because I have too much stuff on my machine.
Given
the following, I don't know if XP SP1 is an option:
try setting a long linesize and printing on 8.5 x 14 paper, landscape
works for me
-bill
-Original Message-
Sent: Wednesday, September 18, 2002 12:43 PM
To: Multiple recipients of list ORACLE-L
I am trying to run utlbstat and utlestat for the first time. The output is
not formatted
Upload the report.txt file to http://www.oraperf.com. You'll have to
register for the service, but it is free. It will reformat the text file
into something quite wonderful...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 18,
Title: RE: bug number 2429929
Soon ...
sorry don't know more than that.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD:
Try running from svrmgr instead of from sqlplus. If you are using a
version
of oracle that does not have sqlplus you should be using statspack instead.
John
John
[EMAIL PROTECTED] wrote:
I am trying to run utlbstat and utlestat for the first time. The output is
not formatted very well.
Ok i hear people complain about the DBID issue when duplicating a
database. Does this only occur when using OS utilities to do the
duplication because the DBID can't be changed until 9ir2?, if you use the RMAN
duplicate command, it appears it works ok,
truth or fiction?
thanks, joe
Thanks Yechiel and Madlen
I was afraid that spreading the IP addresswas going to
be the solution !!!
Tks again
Ramon.
- Original Message -
From:
Yechiel
Adar
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, September 18, 2002 11:48
AM
Subject: Re:
If you name the clone the same name as the db being cloned, then rman won't
change the dbid. After the clone is recovered, you just change the name to
something else. Also I found that if you try to go back to a prior set of
backupsets you will create the DBID problem too. I always use the
Title: RE: Estat Bstat
you could always have the utl*stat report output interpreted by oraperf.com for free.
-Original Message-
From: Ora NT DBA [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Estat Bstat
Title: RE: HELP! CAN't STARTUP REMOTE DATABASE USING SQL*PLUS - BUG?-NA-ARE YOU SURE?
Nope - Tried all that and didn't work - password file, granting sysdba to sys, changing remote_passwordfile_..=exclusive. It is easier to just run shutdown/startup in rman itself. It it was that easy I
Looks like it's data dictionary issue... I think that there are entries in
dependency$ that will need to be cleaned up... Talk to support and mention
Notes 47424.1 and 1015751.102 (there are references to this on metalink but
I can't find the notes)... They should be able to help you clean it
Backup control file with RMAN. 9i makes it easy with
the use of 'configure controlfile autobackup on'. In
8i 'backup current controlfile'
--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Johnson - Congratulations on solving your problem
and thank you for sharing
the solution with the rest of us
On Wed, Sep 18, 2002 at 09:13:31AM -0800, KENNETH JANUSZ wrote:
Has anyone installed MS SP1 on XP Prof?
If so, have you run into any problems?
--
I did earlier this week via a v.90 modem. Took about 2.5 hours
to download the files. Other than that it was uneventful. I
did chose the
Regular table to Object table insert
Greetings,
I'm currentlying prototyping different data model using Object Oriented
facilities provided with 9i and I did hit a wall. I hope one of you guys
can
make that wall crumble.
I have a data model which is exactly mapped to the Object Model. In
Hi.
A developer of mine is running a large insert as
select:
insert /* parallel hint */ into table A
nologging
(select * from table b where ...);
There are no indices on table A and a PK disabled.
Still that insert generates a large amount of logs.
What could be the reason for that? Any
Why do not you try to modify one of them to remove the reference to the
other package and then see if you can drop them?
Use: CREATE OR REPLACE PKG1 new code
You might have tried this already!
Waleed
-Original Message-
Sent: Wednesday, September 18, 2002 6:13 AM
To: Multiple
FOR/LOOP code references a cursor called 'all_terms' while you are asking
about 'all_rules'. Is this just a simple typing error or are you looking at
the wrong spot in your code?
Alec
-Original Message-
C
Sent: Wednesday, September 18, 2002 12:53 AM
To: Multiple recipients of list
Title: RE: log_file_sync io wait question
well if you have mirrored members that exist on the same disk thats an
issue, if this same disk houses the currently used datafiles that would
add to the situation. I placed my redo on a seperate raid-1 and dropped
the member mirrors and see better
Well ...
although you are correct, you forgot to mention that there is a hidden table sys.
fence$, leftover from the archaic time, which (table, not time) has a column drift#
(Boolean) and one row. Default value is FALSE and unless changed manually to TRUE,
the_centripedal_acceleration
Title: RE: Stored procedure - cursor not closed
If it errors out, the cursor stays open. What I prefer is to close the cursor explicitly. That neat, clean and you never make the mistake, just check for the %isopen before you do close though.
Raj
Have you played around with the size and number of your redo logs? Larger redo logs
would mean fewer checkpoints.
Dropping redo log member mirrors is tempting, but RAID alone isn't enough protection.
I experienced a corrupted file system one time, and I was glad that my redo logs were
Hi people...
What to do if I have LOST ALL REDO LOGS and i don´t have any backup?
Thanks in advance!
:
Gilberto Gampert Universidade de Passo Fundo
Administrador de Banco de Dados Passo Fundo - RS -
What about mirrored redo group members?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 18, 2002 4:30 PM
Hi people...
What to do if I have LOST ALL REDO LOGS and i don´t have any
Does you table have many small extents ?
On Wednesday 18 September 2002 21:39, you wrote:
Hi.
A developer of mine is running a large insert as
select:
insert /* parallel hint */ into table A
nologging
(select * from table b where ...);
There are no indices on table A and a PK
Operations that are performed as nologging will still generate redo for the
following:
Space management (updates to the data dictionary)
Undo/rollback (each insert generates an undo entry which generates a redo
entry)
-Original Message-
Sent: Wednesday, September 18, 2002 1:39 PM
To:
Gilberto - Is your database still up, or is it down?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, September 18, 2002 3:30 PM
To: Multiple recipients of list ORACLE-L
Hi people...
What to do if I have LOST ALL
There are all sorts of things you can do to speed up
the process of writing log files:
a) direct io file systems
b) isolate logs onto disks
c) raw
d) faster disks
e) ultra fine grain striping
f) transaction_auditing = false
etc etc etc...but the big key here is:
Each and every record is
The most important - do not panic.
Than, read note 94119.1 on MetaLink.
Here is a part of it:
Recovery with missing online redo logs
Missing online redo logs means that somehow you have lost your redo logs before they
had a chance to archived. This means that crash recovery cannot be
No. It only has 12 extents
--- Anjo Kolk [EMAIL PROTECTED] wrote:
Does you table have many small extents ?
On Wednesday 18 September 2002 21:39, you wrote:
Hi.
A developer of mine is running a large insert as
select:
insert /* parallel hint */ into table A
nologging
Hi Pat
There is not a lot you can do since every commit will force a write to
the disk !
You are hitting that limit of the disk that normally is app. 100 - 120
I/O per sek.
The only real fix is change the application to do less commit's.
It will not help to change the size of the redo log
Dear Lister:
Is there any way to further improve the following query performance ?
Thanks
David Jones
ITResource
SQL select distinct A.*
from POData A , InvData B where A.OWNERID=B.OWNERID AND A.ID =
B.PURCHASEORDERID
and B.Status = 12 and A.ownerId = 1 order by A.ID;
There is a way to reconstruct this files? or startup and reconstruct ?
The database is in noarchivelog...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 18, 2002 5:30 PM
Hi people...
What to do if I have LOST ALL REDO LOGS
Title: RE: HELP! CAN't STARTUP REMOTE DATABASE USING SQL*PLUS - BUG?-NA-ARE YOU SURE?
Now I remember why I didn't do this in version 8.0 of database - the startup/shutdown in RMAN that work in 8i+ gave errors. So until we upgrade those to 8i/9 I guess we live with 2 versions of scripts.
We have several databases spread out over Unix and NT Servers.
I have been given the task to find out what it will take for our users to
log in to the databases with their AD Id/password. Has anybody out there
done this?
Here are some questions I have:
1) Do I need to have Advanced
Gilberto,
Can we assume that the database crashed in the middle of the day or did this
happen when things were quite? I believe you may be in an unrecoverable
situation where you will have to go back to the last cold backup, but you say
that you have no backup which does not give me a good
The only way u can open your database is to add a parameter file
as
_allow_resetlogs_corruption=TRUE
_corrupted_rollback_segments= TRUE
_offline_rollback_segments=(the rollback segment names)
activate the database and then immediately take an export of the whole
database.
Create a new
Nop, all redo logs gone away...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 18, 2002 5:43 PM
What about mirrored redo group members?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple
Does anyone know what these tables are? This looks like something new in
8.17
select table_name from sys.all_tables where owner='MYDEFAULTUSER and
table_name like 'B%' ;
BMC_ISE_CASES
BMC_ISE_CLASSES
BMC_ISE_EVENTS
BMC_ISE_FINDINGS
BMC_ISE_F_TEXT
BMC_ISE_GROUPS
BMC_ISE_INDCOLS
BMC_ISE_INDUSE
[EMAIL PROTECTED] 09/18/02 05:58PM
We have several databases spread out over Unix and NT Servers.
I have been given the task to find out what it will take for our users to
log in to the databases with their AD Id/password. Has anybody out there
done this?
Here are some questions I have:
David
A couple of observations and questions:
- The distinct statement looks fairly expensive. Is there a way to
avoid it?
- Are there any columns on POData? How many rows are in this table?
- How many rows does this query return?
- Do the tables contain the number of rows
Dennis:
1. The distinct seems difficult to avoid.
2. SQL select count(*) from podata;
COUNT(*)
--
18679
SQL select count(*) from InvData;
COUNT(*)
--
83315
3. The query returned no rows at this moment, the reason
I want to tune this query is because it has been
they're from BMC's SQL Explorer product.
either you or ??? demo'd the product or own it.
Drop them if you want. If you were the one that tested SQL Explorer, you
can uninstall the tables using the product.
steve
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Joe,
I have had experiences both ways. I duplicated a
database using the OS and then could not register it with RMAN because of the
duplicate DBID. I also have followed the instructions in the documentation
to duplicate using RMAN and it worked fine and I was able to register it with
RMAN.
Arun, since WHEN has been using undocumented parameters the normal way
of doing things, I think you need to go back and lookup backup/recovery
concepts.
Feel free to read both user managed and RMAN backup recovery docs/scenarios.
You are giving bad advice to people on the list who might be
Well one I do want to make clear I have never tried to give bad advice to
people.
Since the user in his mail had said that he does not have a backup and does
not have any online redo logs can you please let me know how else can he
open the database, when he said he does not have a back it assumes
Hi
Does anybody know how to get the oracle data in the ldif file format. The ldif file
format is usd in LDAP server. My programmers want it that way so I am searching on
that path.
Amol
Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com
Buy Music, Video, CD-ROM,
Arun:
You are right. The original poster *clearly* said
LOST ALL REDO LOGS
NO BACKUP.
In the above situation, you have to open the
databases using the some special tricks and
I don't think you need to go back and refer
BAckup and Recovery Manuals (You can not
find anything for this situation,
100 matches
Mail list logo