(or medium)
databases then I have to disagree with your manager.
Sinardy
-Original Message-
Sent: 26 December 2003 14:59
To: Multiple recipients of list ORACLE-L
Dear :All
Well we did not buy any application packages.
Currently we are using open source product ...which
is Apache
btw, Oracle 10g can add new servers to your database's tier like plug and play (same
OS).
This is what the guy at Oracle 10g seminar told me. He said what an administrator need
is Internet browser.
Sinardy
-Original Message-
Sent: 26 December 2003 15:14
To: '[EMAIL PROTECTED
databases)
Merry X'mas
Sinardy
-Original Message-
Sent: 24 December 2003 09:49
To: Multiple recipients of list ORACLE-L
Dear : All
First and foremost , if i ask stupid question pls
forgive me coz i new to oralce. I have a question
here.
I have a server, and this server contains 5 oracle
Hi
Jeroen,
What
is problem? Error msg or something?
Sinardy
-Original Message-From: Jeroen van Sluisdam
[mailto:[EMAIL PROTECTED]Sent: 16 December 2003
18:12To: Multiple recipients of list ORACLE-LSubject:
alter tablespace offline
Hi,
This
weekend I
Hi,
Those are lines from my friend Oracle University student guide (Original)
Sinardy
-Original Message-
Sent: 16 December 2003 22:34
To: Multiple recipients of list ORACLE-L
Sinardy, where does oracle say anything like that about free memory? Please,
quote me an article or URL
Hi
all,
Why free memory in
v$sgastat is a symptom of the fragmentation?
Why these "free
memory" aremore properly thought of as wasted space?
Thanks
Sinardy
RDBMS can't make use of this space?
everything are in terms of Oracle Block, you can release and reuse the blocks.
Well maybe quite difficult to get long continuous blocks, but it still free space, I
am so blur now
Sinardy
-Original Message-
Sent: 16 December 2003 12:54
To: Multiple
Hi Peter,
pooling is for:
user that connected but idle will be disconnected temporary for new incoming or
outgoing request.
ON or BOTH or YES or TRUE is to turn on
OFF or FALSE or NO is default to turn off
IN for incoming connection only
OUT for outgoing connection only
Sinardy
Hi,
Restartup your database if possible.
If you set the datafile autoextent on then you have to recreate that tablespace,
if you set it to not autoextent on for some query may fail due to not enough sorting
space.
Sinardy
-Original Message-
Sent: 12 November 2003 14:24
To: Multiple
No I am serious
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: 31 October 2003 14:49
To: Multiple recipients of list ORACLE-L
Hi Sinardy,
one little correction: you forgot the winking smiley
at the end of your last sentence ;-)
Greetings,
Guido
[EMAIL PROTECTED] 31.10.2003
. DB Admin
4. Backup and Recovery
5. Network
After you finish all of these you have basic skill, you can be an Oracle DBA.
Good luck.
Sinardy
-Original Message-
Sent: 31 October 2003 11:49
To: Multiple recipients of list ORACLE-L
Hello all,
I am looking for documents saying how
: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E
tablespace and delete the files.
Only if your database size is small or medium.
Sinardy
-Original Message-
Sent: 29 October 2003 17:24
To: Multiple recipients of list ORACLE-L
I don't beelive you can drop a datafile from a tablespace, you have to drop
the tablespace, just reaize
://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing
ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
1. create the new role
2. create script
spool /tmp/move_role.sql
select 'alter user ' || grantee || ' grant new_role;' from dba_users where
granted_role = 'OLD_ROLE'
host more /tmp/move_role.sql
--@/tmp/move_role
Sinardy
-Original Message-
Sent: 23
). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
If
you want to reduce your consistent gets, you can reduce your sga size
-Original Message-From: Sultan Syed
[mailto:[EMAIL PROTECTED]Sent: 08 October 2003 14:14To:
Multiple recipients of list ORACLE-LSubject: consistent
gets
Hi,
What does the meaning for this
BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED
') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
**
Good luck
Sinardy
-Original Message-
Sent: 02 October 2003 13:50
To: Multiple recipients of list ORACLE-L
Here are the stats if you're interested. I can't run dbms_space on the table because
it will lock up the application. This table is accessed ALL the time. It grabbed
another
Hi Kaing,
Have you check the degree of fragmentation?
have you check your extent size?
Sinardy
-Original Message-
Sent: 01 October 2003 14:20
To: Multiple recipients of list ORACLE-L
Hello everyone,
Env: 8.1.7.4, SunOs 5.8 64 Bit
We seem to hitting bug 1262161. The bug seems
.
Sinardy Xing
[EMAIL PROTECTED]To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED
ORACLE_SID=______
Sinardy
-Original Message-From: Daiminger, Helmut
[mailto:[EMAIL PROTECTED]Sent: 22 September 2003
17:55To: Multiple recipients of list ORACLE-LSubject:
two instances on same box (Suse Linux ES 8)
Hi!
We are running 2 Oracle instances on one Suse Linux
). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn't
mttaer
in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng
is
taht frist and lsat ltteer is at the rghit pclae. The rset can be
a
toatl mses and you can sitll raed it wouthit porbelm. Tihs is
bcuseae we
do not
, but there must be a way to prevent internal(sys) or system from
coming in.
Sinardy
-Original Message-
Sent: 01 September 2003 18:05
To: Multiple recipients of list ORACLE-L
Hi!
I have an idea
1. Use let say My_Tursted_SA schema, write a trigger that will disconnect
new login as SYS
(sys) or system from
coming in.
Sinardy
-Original Message-
Sent: 01 September 2003 18:05
To: Multiple recipients of list ORACLE-L
Hi!
I have an idea
1. Use let say My_Tursted_SA schema, write a trigger that will disconnect
new login as SYS or SYSTEM
How exactly are you planning
Hi Zhu Chao,
Yes, I think Jin is using shared external storage, otherwise if his server A down how
he going to copy all his files from
server A to server B.
if this is the case what Jin may do is propose an clustering software.
Otherwise, he must backup his database into media.
Sinardy
Hi John,
Have you check your sqlnet.ora parameter?
perhaps you want to try to add
GLOBAL_DBNAME = hostname
in your init.ora?
Sinardy
-Original Message-
Sent: 01 September 2003 16:59
To: Multiple recipients of list ORACLE-L
Having problems getting Oracle 8 client working with DNS
RAID 0 + 1 if you have the $$$.
Sinardy
-Original Message-
Sent: 02 September 2003 11:29
To: Multiple recipients of list ORACLE-L
Hi Greetings,
We are using solaris. I wonder how to startup oracle after machine
is bootup and how to shutdown oracle before unix is shutdown?
I know how
Hi Tanel,
Very good post,
because we are using clustering then I think Jin can have easier life with one,
everything is like semi automatic.
Sinardy
-Original Message-
Sent: 02 September 2003 17:44
To: Multiple recipients of list ORACLE-L
Hi!
You can do what you wanted without
chapter special for this in DB Administration doc.
I read from Unix administration book long ago, the author said something like this
replace the rm binary to something like this:
cp rm .rm.original
echo .rm.original -i rm
May be is not a good book, I don't know...
Sinardy
Hi all,
I think as a DBA you should have the root password for the database server.
Will this close the case?
Sinardy
-Original Message-
Sent: 03 September 2003 03:09
To: Multiple recipients of list ORACLE-L
Instead of trying to do things in software, which was designed
I have an idea
1. Use let say My_Tursted_SA schema, write a trigger that will disconnect new login as
SYS or SYSTEM
2. If you want to use sys or system, you login as My_Trusted_SA disable the trigger.
What do you think?
Sinardy
-Original Message-
Richard Ji
Sent: 31 August 2003 13
RF tell me if I am wrongPS: Just kidding.,
going to see Mars tonight I miss my home town.
:)Sinardy-Original Message-Sent:
28 August 2003 06:25To: Multiple recipients of list
ORACLE-LWomen are also particularily good at remembering small
nasty things from
pictureso either I am more highly
evolved and use both sides of my brain (nothardly) or the theory needs
some modification--- Sinardy Xing
<[EMAIL PROTECTED]>wrote: Hi, This is my
own theory, you can't find this information from Oracle
Document. Well... talking about
by you)
is not
Sinardy
-Original Message-
Sent: 29 August 2003 12:34
To: Multiple recipients of list ORACLE-L
DABs,
Is there any way in my connection to get the sid and serial# for my own
connection?
Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED]
In this connection
Hi,
Unique(companynumber, type)
or
you combine 2 columns together
CompanyNumber_Type (this can become primary key, I don't think you need the id column,
pseudo column rownum is the same)
You have lesser indexing
123_1
123_2
Sinardy
-Original Message-
Sent: 29 August 2003 18:24
use your left brain when
talk to women, then she is yours.
RF tell me if I am wrong
PS: Just kidding., going to see Mars tonight I miss my home town. :)
Sinardy
-Original Message-
Sent: 28 August 2003 06:25
To: Multiple recipients of list ORACLE-L
Women are also
changes too most likely
cannot connect too.
If is not ONS then you can reference your client machine setting.
hope this can help you, good luck
Sinardy
-Original Message-
Sent: 28 August 2003 14:19
To: Multiple recipients of list ORACLE-L
Guru:
I need help with an error ORA-12640
') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL
from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Title: Message
Hi
all,
Thanks
for your input...
I am
using
Oracle 8i
On-Line Generic Documentation
CD-ROM
Part #: A87860-01
The
solution: I just copy all the d:\doc to my hd (quite huge) then open the
index.htm
This
is huge man, I only have 30 gig storage
Sinardy
Title: Message
Hi,
Thanks
this work.
Sinardy
-Original Message-From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]Sent: 22 August 2003
20:59To: Multiple recipients of list ORACLE-LSubject:
RE: Online Document for Windows XP Home edition Severity
3
Sinardy
.
3.
According to Unix book (I don't remember the title of the book) it said "The
lesser the users the more secure your system" (I agree with this
line)
Just
my opinion...
Sinardy
-Original Message-From: Joshua Becker
[mailto:[EMAIL PROTECTED]Sent: 25 August 2003
find real problems there + solution.
Will you give me one copy of your ebook?
Sinardy
-Original Message-
Sent: 23 August 2003 21:09
To: Multiple recipients of list ORACLE-L
Dear All,
I am collecting (Just writing in a book ) of all tough problems , great
issues handled with Oracle
Hi,
This group is kind of boring for me because I don't have chance to answer questions,
those gurus are so fast, they reply almost everything.
they told you wasn't so smart or wasn't so... smart :)
Sinardy
-Original Message-
Sent: 25 August 2003 18:00
To: Multiple recipients of list
Hi
all,
I have new notebook,
I want to install Oracle Doc 8.1.7, but Oraclefail to run when I
clickInstall/Deinstall button
Some said XP home
edition cannot install Oracle, is this because Sun demand Ms
toremovethe JVM? Can someonehelp me
please..
Thanks
Sinardy
Hi Zhou,
This most likely becoz your OS is incomplete
you must install FULL DISTRIBUTION VERSION
Upgrade your OS
Sinardy
-Original Message-
Sent: 18 August 2003 17:14
To: Multiple recipients of list ORACLE-L
I am trying to install Oracle 8i release 3 (8.1.7.0.0
a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network
a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City
and start sending in the good stuff.
On 2003.08.18 00:44, Sinardy Xing wrote:
Hi Canada and US friends,
Can your systems survive the blackout disaster?
Do you need recovery? Everything is ok out there?
Sinardy
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http
Hi Canada and US
friends,
Can your systems
survive the blackout disaster?
Do you need
recovery? Everything is ok out there?
Sinardy
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
returns
How to get something like this
CustomerNo 1 Total Order For This month = 0
I tried this
nvl(to_char(dateorder, 'month'), 'JUNE') = 'JUNE'
Thanks
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Hi Castro,
Can you set yourfont size
bigger? You are not lawyer right?
may be this can help
you
UPDATE table SET column =
something_new
WHEREprimary_key_or_just_keyin (select foreign_or_primary_key
asusual)
AND other_key in
(other select foreign_or_primary_key
asusual);
Sinardy
++=
+save as imp.bat***
sqlplus -s someone_can_do_select_v$database/[EMAIL PROTECTED]
+++
You can add alot of fancy stuffs but the concept is about like that
Sinardy
problem but the fiber card.
Sinardy
-Original Message-From: laura pena
[mailto:[EMAIL PROTECTED]Sent: 18 June 2003
01:10To: Multiple recipients of list ORACLE-LSubject:
Anyone using EMC Clarion Cx400 in a RAC environment?
Looking at purchasing an EMCClarion Cx400 for our 2 Sun
Hi all,
Do you install Oracle RDBMS (maybe personal edition) with Win XP?
Will that work?
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
Hi Pomin,
This is syntax error, why don't
you check your create database syntax including init.ora file and system
environment variable.
Just my
speculation.
Sinardy
-Original Message-From: pomin
[mailto:[EMAIL PROTECTED]Sent: 19 March 2003 09:49To:
Multiple recipients
Hi,
Or may be because IBB is in the queue, that why it seems like not working.
Just my speculation
Sinardy
-Original Message-
Sent: 18 March 2003 17:09
To: Multiple recipients of list ORACLE-L
Inband breaks are (were) not supported by all protocols and not all
implementations
activity)?
Thanks,
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Hi all,
Can someone help me understand this...
ROOT # TEST=${2:-.}
ROOT # echo $TEST
ROOT #.
what is 2:-.
another similar code
ROOT # TEST=${1:-0}
ROOT # echo $TEST
ROOT # 0
they looks like emoticon for me
Thank you
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
a lousy dba, he he he...)
the problem never occur again, and my database
life happily ever after.
Sinardy
-Original Message-From: Nguyen, David M
[mailto:[EMAIL PROTECTED]Sent: 26 February 2003
09:44To: Multiple recipients of list ORACLE-LSubject: It
takes too long
Hi all,
I am writing a script that can grep ORA- from alert log.
I think it will be good if I can grep the time of the error occur, can you please help
me?
If you are lazy to type please introduce me any related unix function, I will do man
the function myself.
Thanks
Sinardy
--
Please
the export dump file (compress = n full=y)
then reinstall Oracle binary files, this is quite fast, right?
Sinardy
-Original Message-
Sent: 24 February 2003 16:39
To: Multiple recipients of list ORACLE-L
Hi all,
I have a test installation of Oracle 817 and 902 on my PC - installed
completly
.
Sinardy
-Original Message-
Sent: 27 January 2003 23:44
To: Multiple recipients of list ORACLE-L
we plan to upgrade ORACLE 8.1.7 to 9.2 on SUN Solaris server. I plan to
upgade to 9.2 use oracle account and keep 8.1.7 on ora817 account. I
create user ora817 and assign it to dba group. I also
Title: Case of the Missing Rows
I
think so too, perhpas you want to include the bad recordto capture those
bad records
make
the nesassary changes then load that bad file
repeat
until all loaded into your db
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: 28
Hi Big
Planet,
They
db files are not consistence you can apply the changeswith archived redo
log since.
How
you recover your database is depend on how you backup your
database.
For
example you can use old "redundancy set" + latest exported dump
file
Sinardy
-Origin
to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Hi IT friends,
Do you know any 3rd party software (other than Adobe Acrobat) that convert few hundred
pages of PDF to TXT.
Sorry for the OT but please guys, is quite urgent thanks
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL
Hi all,
Thanks for your reply.
I find a command pdftotext from Red Hat
Use a script run it very fast all my pdf files are now in text files.
Enjoy your weekend :)
Thank You
Sinardy
-Original Message-
Sent: 10 January 2003 17:59
To: Multiple recipients of list ORACLE-L
Hi
Hi Sony,
Commit will slow down your script. (I mean use the reasonable number of transactions
per commit)
Perhaps you can set your Rollback segment optimal value to null.
Your rollback will never shrink : )
Sinardy
-Original Message-
Sent: 06 January 2003 10:09
To: Multiple recipients
If you are not require to know those table structure differences then you can drop the
tables first.
Other Important Note: Make sure your dump file exported with parameter compress = n
Sinardy
-Original Message-
Sent: 06 January 2003 16:34
To: Multiple recipients of list ORACLE-L
I
Hi John Dunn,
My answer is never commit, Oracle will rollback.
Are you consider auto commit an implicitly commitment?
Sinardy
-Original Message-
Sent: 02 January 2003 22:14
To: Multiple recipients of list ORACLE-L
Under what circumstances is a COMMIT done implicitly?
If I call
.
Sinardy
-Original Message-
Sent: 06 January 2003 17:04
To: Multiple recipients of list ORACLE-L
Hi,
I want to move ( insert into select and than delete from ) some
records of a table to another one at midnights. It would be very nice if it
has logging facility.
Do you have any
Hi all,
I hit by this error
ORA-00600: internal error code, arguments: [2662], [0], [54151123], [0],
[54173017], [16781180], [], []
Can you help me where to find info about this error
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET
Hi guys,
This is what I get from Oracle
==
Hi Sinardy,
I've check several bug looking for the cause of this problem. However, what I've found
is that Development could not diagnosis the problem other than the possibily hat
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
'
from user_objects
where object_name = myuser
order by creation;
do you think this will work ?
My problem is with referential
Thanks
Mery X'Mas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858
for
second node to do startup pfile=
the problem is shutdown abort successful but the mounted points cannot be unmount
because of those
UNKILLED background processes.
I think sun clustering shuold add this
if cannot release mount point then do STOP A follow by power off, right ?
Sinardy
Hi all,
Can I set this file to r-xr-xr-x ?
rwxrwxrwx /opt/oracle/product/jre/1.1.8/bin/jre
Thanks
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
Hi all,
When I do shutdown abort my LGWR and CKPT still around and also kill -9 cannot get rid
of them anyone know why ?
because of this my cluster fail to failover
Thanks
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED
send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web
when I do
echo $file_tag1
it should give me 001
Thank you
sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
Hi Jared,
Noted,
thanks.
Sinardy
-Original Message-
Sent: 24 August 2002 03:45
To: Multiple recipients of list ORACLE-L
Not only is it not supported, it has been know on
occasion to trash a database.
I tried it years ago, several procedures could not
be recompiled after doing so
them copy to tape.
Sinardy
-Original Message-
Sent: 20 August 2002 14:34
To: Multiple recipients of list ORACLE-L
Hi,
The logic should be like this
1. tablespace begin backup
1a. archive log current
2. suspend database (or sleep)
3. EMC synchronized standard volume and bcv
Hi guys,
Anyone that work in ASIA time please help me : )
Sinardy
-Original Message-
Sent: 08 July 2002 12:58
To: Multiple recipients of list ORACLE-L
Hi guys,
I try to create standby database and my datafile are all over my hard disk, what
should I do to my DB_FILE_NAME_CONVERT
is very funny if I have to rename all my production data files before I
create standby control file. :(
Thanks
Sinardy
-Original Message-
Sent: 08 July 2002 16:03
To: Multiple recipients of list ORACLE-L
Hi,
I don't know the syntax you are looking for but you could explicitly rename
(like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
)
Thanks so much.
Oh by the way I am using 8i
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access
: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself
: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself
Hi all,
I try to install Oracle IAS 8i into my Win 2K SP 2, and the universal installer is
hang, any idea (I have huge RAM)
Thanks
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
Hi
Santosh,
Tablespace is logical storage, datafile is physical storage (OS
file).
Tablespace mustconsists of at least 1 datafile.
Example
Create
tablespace my_tablespace
datafile 'my_tablespace's_datafile1'
NB:
Storage is storing your database objects
Sinardy
-Original
d the last
SCN.
Oracle
Concept Document is a very good source of knowledge, everything you want to know
including "redundancy set" and "SCN"
Sinardy
-Original Message-From: Santosh Varma
[mailto:[EMAIL PROTECTED]]Sent: 11 June 2002
15:13To: Multiple reci
into my Win 2K SP 2, and the universal
installer is hang, any idea (I have huge RAM)
Thanks
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
1 - 100 of 234 matches
Mail list logo
