santosh:
Thanks for the help The following
query also worked fine .
Select count(tc_transcriptid) file_count ,
Sum(Tc_LineCount),
trunc(tc_collectdatetime)From
dc_transcript_collectwhere
(Tc_TranscriptId,Tc_ActionId)
in (Select
Tc_TranscriptId,Max(TC_ActionId)From
Dear Gurus ,
I want to ask something ..
I want to apply a standby server ,What I
wonder is , if I set it up automatic , is the archive log files
automatically copied to standby server , or do I move it manually .
???
And my second question is on my Win2000 Adv. Server
C:\ drive ,
Hi all,
Is it possible to rename files (e.g .txt files) on Unix by using PL/SQL? Is there a function to do that?
Regards
M.Emre HANCIOGLU
Masterfoods Services GmbH
ISI Application Support
Tel : +49 2162 500-576
Fax: +49 2162 41497
E-Mail: [EMAIL PROTECTED]
yes , if you put in "maneged mode" , archived
logs are copied and applýed to standby site from master
site.
- Original Message -
From:
Bunyamin K. Karadeniz
To: Multiple recipients of list ORACLE-L
Sent: Friday, April 19, 2002 12:03
PM
Subject: STANDBY DATABASE
Ray,
Have you looked at Embarcardero's DBArtisan tool? I'm not sure if it will do
an active compare of the schemas etc. but it certainly works on both Oracle
and SQLServer concurrently, and is in the ballpark that you are looking
for..
May be worth checking it out:
www.embarcadero.com
HTH
Original Message-From: Bunyamin K. Karadeniz
[mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 2:33
PMTo: Multiple recipients of list ORACLE-LSubject:
STANDBY DATABASE QUESTION?
Dear Gurus ,
I want to ask something ..
I want to apply a standby server ,What I
There are about a dozen in North America and Europe that I know of, but
can't name (NDA). There was one person I met at IOUG-A Live! 2002 that is
actually live on it in production - and it isn't running anything truly
critical, more of a pilot system. I have one client who wants to pounce on
it
Hi,
no,
there's no way to do that through PL/SQL.
If
have the option of using java you can use the solution given by Tom Kyte at http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840241
Regards,
Mike
Hately
-Original Message-From: [EMAIL PROTECTED]
- Original Message -
There is a new alternative. SAPDB is open source but supported by SAP.
Whan
used outside of SAP applications it is free but charged when used inside
of
SAP. The support is from a major software company and the features are
much
closer to the Oracle feature set.
1) Zoned decimals is something like hex 'F1F2F3' for 123.
2) Those numbers are not zoned decimal. They look like packed decimal
with the last byte reversed. 'A' is 'C1' in hex and that means 1 positive.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L
But you may have to close the listener and activate the listener
of the new version and that means that you better close the instances also.
The same for oracle agent and maybe other services.
I think that you should check this on a test machine first.
Yechiel Adar
Mehish
- Original Message
Hello,
I get often ORA-00600 [12333], [0], [0] in a database
(8.1.7.0 AIX 4.3). I openned a TAR but they just said there
were lost of connections. Does anyone have the same problem
and how to get rid of it please ?
Thank in advance.
Thanh-truc Nguyen
Below is the header of the trace file :
I agree with Scott's reply. Compaq may be able to claim the only Tru RAC,
but not the only true RAC!
I skipped the keynote/marketing stuff at IOUG-A Live! 2002, but I've seen
the long version of Compaq 's demo/propaganda on RAC and, to put it
mildly, they exaggerated - A LOT. I don't know what
Hallo,
anyone whom can help me. I would like this code to send email to two recipients, what
is missing?
Thanks for all help I can get.
PROCEDURE sendmailtestny2(
inRecipient1 IN VARCHAR2,
inRecipient2 in VARCHAR2,
From 8.1, the primary node can automatically transfer
the logs to the standby node.
hth
connor
--- Vikas Khanna [EMAIL PROTECTED] wrote:
Original Message-
Sent: Friday, April 19, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L
Dear Gurus ,
I want to ask something ..
In Outlook, when I put two addresses in TO or CC or BCC fields, they are
separated by a semi-colon(;). It appears that your code is placing carriage
return. I do not know if the code will understand this semi-colon as command
terminator. Otherwise you might want to use the CC or BCC fields for
Which reminds me of a joke I heard once.
You know what the difference between
a used car salesman and a computer salesman
The used car salesman usually knows when
he is lying!
ba-dum-dum
John
[EMAIL PROTECTED] wrote:
I agree with Scott's reply. Compaq may be able to claim the
Come On Walt...
I thought you installed Windozz first to allow the Oracle to
install without a hitch and then upgraded your pc to Linux. Nt first,
SP4,SP5,SP6 then Oracle 8.0, migrate to 8.1.6, upgrade to 8.1.7, patch
up to 8.1.7.3, and if your lucky migrate to 9.0.1. When all is said and
Regarding the Enqueues:
One follow-up is to connect as SYS and look at
x$ksqst where ksqstwat != 0. This tells you two
things (after the event). First, which type of
enqueue has suffered waits, and secondly whether
the waits in v$session_wait are represent a few
very long waits or lots of
ALERT NUMBER 1: UNAUTHORIZED ACCESS VULNERABILITY IN THE ORACLE E-BUSINESS SUITE.
Document Identification Number 185073.1
ALERT NUMBER 2: USER PRIVILEGES VULNERABILITY IN ORACLE9i DATABASE SERVER
Document Identification Number 185074.1
What
about issueing a HOST command through dbms_sql? Not saying it will work (I
haven't tried it)
but it
seems like it should.
-Original Message-From: Hately Mike
[mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 5:53
AMTo: Multiple recipients of list ORACLE-LSubject:
it helped with CC:
Thanks
/Roland
Abdul Aleem [EMAIL PROTECTED]@fatcity.com den 2002-04-19 03:48 PST
Sänd svar till [EMAIL PROTECTED]
Sänt av: [EMAIL PROTECTED]
Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Kopia:
In Outlook, when I put two addresses in TO or CC or BCC
This is hugely irritating, and I guess it may be a
version-dependent thing, but I can't get the exact
match for the quoted locks by setting up three
tables in the manner described.
The locking information varies between 8.1.7.3
and 9.0.1.3, but I can't get a PK/FK issue to
behave (mis-behave ?)
HOST is a SQL*Plus command only.
--- John Weatherman [EMAIL PROTECTED] wrote:
What about issueing a HOST command through dbms_sql? Not saying it
will
work (I haven't tried it)
but it seems like it should.
-Original Message-
Sent: Friday, April 19, 2002 5:53 AM
To: Multiple
Bruce:
You got the point. We have discussed that some time back (Steve, Jonathan,
and Adrian Cockcroft) and the result was:
Few Faster CPUs are better for Performance, More slower CPUs are better for
Manageability and fault tolerance.
Steve Adams and Adrian are with few faster CPUS and Jonathan
Oracle waits normally 3 seconds on a TX enqueue, checks for interrupts
and goes again to sleep for 3 seconds. So if we see 307 on average, we
waited longer. Now there may be tons of reasons of why that is:
scheduling, granularity, etc. The thing to know/remember is that an
enqueue wait is
I've got a little lost about who has said what in answer to
whom about what - so apologies if I'm repeating comments,
answering non-questions and giving incorrect attributions.
The primary problem appears to be that performance
plunges dramatically when concurrent increases.
Three tkprof
1. Read the oracle docs on either 8i standby database, 9i data guard,
log transport services and log apply services.
joe
Bunyamin K. Karadeniz wrote:
Dear Gurus ,
I want to ask something ..
I want to apply a standby server ,What I wonder is , if I set it up
automatic , is the
Vikas, you need to read the docs also, you can have the logs
automatically shipped and applied to the standby database, it all
depends on how you set it up.
the docs are a wonderful thing.
joe
Vikas Khanna wrote:
Original Message-
*From:* Bunyamin K. Karadeniz
Yes next year back to orlando.
joe
Ron Rogers wrote:
Come On Walt...
I thought you installed Windozz first to allow the Oracle to
install without a hitch and then upgraded your pc to Linux. Nt first,
SP4,SP5,SP6 then Oracle 8.0, migrate to 8.1.6, upgrade to 8.1.7, patch
up to
Arslan, not exactly managed mode applies the logs, you need to setup the
primary init.ora to have the shipped from primary site to standby site.
joe
Arslan Bahar wrote:
yes , if you put in maneged mode , archived logs are copied and
appled to standby site from master site.
-
I will be in training the week of April 22nd to April 25th.
I will respond to your e-mail when I return on April 26th.
Don
ORACLE-L 04/19/02 09:48
1. Read the oracle docs on either 8i standby database, 9i data guard,
log transport services and log apply services.
joe
Bunyamin K.
thank you all...
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729
The degree of normality in a database
is inversely proportional to that of its DBA.
- Original
Hi
You can read the articles ( + other articles ) of
Donald Burleson at www.DBResources.com
Thanks
Jason
--- YTTRI Lisa [EMAIL PROTECTED] wrote:
Hi -
Does anyone know if Donald Burleson has a website?
If so, do you
have the
url?
Has anyone read his book 9i Unix Administration
Hi
Check the document below which discusses the
differences in Oracle and SQL Server databases.
http://www.dbresources.com/modules.php?name=Newsfile=articlesid=86
Thanks
Jason
--- Tim Gorman [EMAIL PROTECTED] wrote:
...this is even worse than the myth that programming
to the ANSI SQL
Again: needed time is 1.76
20 jobs require 1.76 * 20
Divided on 4 cpu
each cpu will take 1.76 * 20 /4 = 8.8 sec
This is the average elapsed time for any job (20 concurrent) on your
system.
regards,
Waleed
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent:
My view:
if you have a lot of contention: few fast CPUs
if you have virtually no contention: few fast CPUs or large number of slower CPUs.
if you have a lot of contention and a large number of slow CPUs, your contention
will become worse (basically it will take longer to execute the
Unfortunately, support is correct. But to add a bit more: 600/12333
indicates that the two task layer in Oracle (just above sqlnet) has received
a function code, that it does not understand. I've been involved in a few
cases with this error, and we did also not reach any conclusion. My
Hi
Check the document below which discusses the
differences in Oracle and SQL Server databases.
http://www.dbresources.com/modules.php?name=Newsfile=articlesid=86
Thanks
Jason
--- Tim Gorman [EMAIL PROTECTED] wrote:
...this is even worse than the myth that programming
to the ANSI SQL
Which, of course was written by MS in MS Wurd format, which promptly locked
up when I tried to close it. Figures.
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Jason
The elapsed time taken can not change for this stress test except by
improving the cpu time needed to execute a single task.
So to improve the numbers some tuning needed on the sql.
The average elapsed time for (n concurrent jobs) = x * n / c sec
x = cpu time needed to execute a single
Hi
There have been some postings related to Oracle licensing.
An interesting article:
http://www.sacbee.com/content/politics/story/2219532p-2613285c.html
Witold
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Witold Iwaniec
INET: [EMAIL PROTECTED]
Fat City
Hi,
We have a job own by user MTSSYS which we scheduled to run every 1 minute but it is
not running itself.
If we run the job manully from sqlplus it runs fine.
What can be the reason that job is not running itself???
Interval is set to SYSDATE+1/1440
Thanks
--Harvinder
--
Please see the
Calls to sys.dbms_system.ksdwrt to add entries to the alert log mysteriously
insert a space infront of the string and sometimes doesn't
SERVERERROR[955] SESSION 17,355 USER SYSTEM,oracle PROGRAM sqlplus@foo (TNS
V1-V3),foo
SERVERERROR[955] SESSION 13,5385 USER SYSTEM,oracle PROGRAM sqlplus@foo
Search on ora-00600 lookup, it should come up as the first doc on the
list.
Brian P. MacLean
Oracle DBA, OCP8i
Paul Vincent
Hi,
We have an ETL script that logs onto the db. The scripts usually runs without
error. During pre-production testing, we rec'd a logon denied error message. We
re-ran the scripts and all was fine.
I did not see anything in the alert log, only message for today was a redo
Hello All,
We are observing a strange problem for a couple of days. One of our batch
process which usually takes about 30 minutes to complete sometimes takes upto 8
hours to complete and this varies even though the batch load is almost the same
everynight.
Some details on the job
The job is
Hi Anjo,
Q1: Are you running
multiple jobs at the same time ? Could be true because you are running out
of
CPU
How can you tell we are running out of CPU???
We are a development shop and have about 30 instances running on a single
database server. There was just one major job running on
If I find a file in Mac format and don't have a tool to open it, I guess I
should blame Mac...
Witold
On 19 Apr 2002 at 8:13, Jesse, Rich wrote:
Which, of course was written by MS in MS Wurd format, which promptly
locked up when I tried to close it. Figures.
Rich Jesse
Did you set JOB_QUEUE_PROCESSES and JOB_QUEUE_INTERVAL in your
initsid.ora parameter file?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, April 19, 2002 12:13 PM
Hi,
We have a job own by user
Jonathan,
Thanks for your response. The programmer stopped the process last night
because it was taking too long ... so there was nothing in x$ksqst when I
looked this morning. However, thanks for the tips on how to troubleshoot
this further.
Can I confirm that your report is describing a job
What is/are the settings of JOB_QUEUE_INTERVAL and JOB_QUEUE_PROCESSES in your
init.ora.
Dick Goulet
Reply Separator
Author: Harvinder Singh [EMAIL PROTECTED]
Date: 4/19/2002 8:13 AM
Hi,
We have a job own by user MTSSYS which we scheduled to run
Jesse,
What did you expect? It's from MSDN (MicroSlut Developers Network).
Dick Goulet
Reply Separator
Author: Jesse; Rich [EMAIL PROTECTED]
Date: 4/19/2002 8:13 AM
Which, of course was written by MS in MS Wurd format, which promptly locked
Hi
I want to do sync two database once in a day.I have one database named test1
on one server and another db named test2 on other server.I want to sync 10
tables from db test1 to db test2 and 20 tables from db test2 to db test1.
How can I do this?Is is only way to go replication?IS any other
Hi
I want to do sync two database once in a day.I have one database named test1
on one server and another db named test2 on other server.I want to sync 10
tables from db test1 to db test2 and 20 tables from db test2 to db test1.
How can I do this?Is is only way to go replication?IS any other
There is a level parameter in ksdind I believe, so just before you call ksdwrt,
call ksdind(0). the lvl controls the indentation (sp?).
Anjo.
Post, Ethan wrote:
Calls to sys.dbms_system.ksdwrt to add entries to the alert log mysteriously
insert a space infront of the string and sometimes
Seema - You could buy a separate replication package to do this, but you
probably couldn't justify the cost.
You could simply write some scripts to do this. But if you use
Oracle's Basic Replication, then you get some resume material as a bonus.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL
If the parameters suggested are already set up right , I have one more thing
to ask...
1. is this something do with the DB Link ???
2. if so , the user running the job is having any private DBLINK ???
--Madhu
PS: If the DB LINK is used to run this job , you need to have a private
dblink
Now that depends on how big the tables are? A few options off the top of my head:
1) Drop tables, export, import.
2) Replication.
3) Truncate, insert from select as.
4) Spool data, sql*load it.
so many ways to skin a cat...
I would probably play w/ replication.
[EMAIL PROTECTED] 04/19/02
Is the table partitioned?
Also, do you have any money for reorg tools?
What sort of maintenance window do you have to complete this reorg? Can
you negotiate for a larger-than-normal maintenance window?
Cherie
If I use Borland Delphi 5 for user interface and Oracle 8i for the database.
How to set the value of EMP_ID column as a Primary Key(PK) of EMPLOYEE table
?
Note:
The PK was generated automatically by a sequence number 'EMP_SEQ',
and it works normally on Oracle Form.
TIA,
Ferry Situmorang:
Are there any jobs running? There's a couple of init.ora parameters that must be set
first.
Jim
-Original Message-
Sent: Friday, April 19, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
If the parameters suggested are already set up right , I have one more thing
to ask...
1.
Hello,
Our DB has a GMT time zone, while our data
warehouse has EST.
For our application, some guys here insist that we
store dates as varchar2 to avoid all the problems
associated with data in the two databases.
Though personally I want the dates to be stored in
oracle date datatype,
- Original Message -
From: "Jason Rowski"
Check the document below which discusses
the differences in Oracle and SQL Server databases.
http://www.dbresources.com/modules.php?name=Newsfile=articlesid=86
what about:
Category
Microsoft SQL Server
Did you commit after submitting the job or the session is still open?
Waleed
-Original Message-
Sent: Friday, April 19, 2002 12:14 PM
To: Multiple recipients of list ORACLE-L
Hi,
We have a job own by user MTSSYS which we scheduled to run every 1 minute
but it is not running itself.
LOL!
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Marin
Dimitrov
To: Multiple recipients of list ORACLE-L
Sent: Friday, April 19, 2002 3:19
PM
Subject: Re: Good Article on differences
between ORACLE and SQLServer
- Original
Title: schedule Oracle stored procedure
i've got the answer, for all those wanting to know, it's :
dbms_job.submit (:jobnumber,'myproc(' 'proc_parameter' '); ',
SYSDATE,'NEXT_DATE(TRUNC(SYSDATE), ' 'friday' ') + 17/24') ;
(executes a SP every friday at 5pm)
if anyone has a better solution,
Title: executing a stored procedure at a certain time
Read on DBMS_JOB oracle-supplied package in docs.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Nelson Flores
To: Multiple recipients of list ORACLE-L
Sent: Friday, April 19, 2002 3:53
PM
Title: executing a stored procedure at a certain time
Schedule the stored proc as a job using 'EXEC DBMS_JOB.SUBMIT'
Dave
-Original Message-From: Nelson Flores
[mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 2:53
PMTo: Multiple recipients of list ORACLE-LSubject:
Title: executing a stored procedure at a certain time
You
can schedule it as a database job. Look into the dbms_job package and
section about database jobs
in the
admin guide.
-Original Message-From: Nelson Flores
[mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 3:53
dbms_job. See the SQL guide for your particular version of Oracle at
http://technet.oracle.com
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Nelson Flores [SMTP:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 2:53 PM
To: Multiple recipients of list
Sais
I am takling about replication.The assumption is tables are having millions
of rows.In case if one Db server down i want to fail over to another one
also.Which option in replication would be good Is it Multimaster
replication.
Thx
-seema
From: Gene Sais [EMAIL PROTECTED]
Reply-To:
Sais
I am takling about replication.The assumption is tables are having millions
of rows.In case if one Db server down i want to fail over to another one
also.Which option in replication would be good Is it Multimaster
replication.
Thx
-Dinesh
From: Gene Sais [EMAIL PROTECTED]
Reply-To:
Title: executing a stored procedure at a certain time
Check
out Oracle jobs (dbms_jobs package). It's pretty easy.
Prakash
-Original Message-From: Nelson Flores
[mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 3:53
PMTo: Multiple recipients of list ORACLE-LSubject:
Sorry to get on this thread so late...
To answer Emre's question, we can do it if you have a extproc listener
configured and have a external procedure to do the same.
Babu
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, April 19, 2002 8:53
Is there any additional software required if i go to advanced replication?
-seema
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: REPLICATION/FAIL OVER
Date: Fri, 19 Apr 2002 10:03:57 -0800
Seema - You
Seema - Another alternative you may want to check out is transportable
tablespaces, since you just want to sync the databases up once/day. I think
this will require less maintenance than replication.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday,
Since I started this thread, I thought I'd update everyone on what the
problem ended up being. There is a problem with one of the power supplies
on the switch in the SAN. The other power supply was not plugged in, so it
halted everything occasionally. We plugged the other power supply in, and
Seema,
Excuse me for spitting out ideas. You mentioned replication as one method and were
unsure of this method. You also expressed interest in alternative methods besides
replication of which I mentioned a few. Good luck in your search.
Gene
PS. BTW, replication is not a good tool for
Babu,
can you give an example ?
thanks
Santi
-Original Message-
Sent: Friday, April 19, 2002 1:38 PM
To: Multiple recipients of list ORACLE-L
Sorry to get on this thread so late...
To answer Emre's question, we can do it if you have a extproc listener
configured and have a external
Hi Jonathan/Anjo/Sam:
Let me say that v$system_event (and I assume it´s valid for v$session_event
too) does not report
the enqueue average wait time correctly. (unless until version 8.1.6, I
don't know what version are you using)
To calculate the precise number of enqueue waits you have to use
Seema - Advanced replication is a feature of Oracle Enterprise Edition, so
if you have that, you should be set. Based on your description, updatable
snapshots may meet your needs, and be simpler to configure and maintain.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
Very interesting. So the EMC box didn't 'phone home' like it was suppossed
to, to report this problem?
Thanks for sharing this Scott.
Lisa Koivu
Oracle Database Blue Softball Ankles
Fairfield Resorts, Inc.
Office: 954-935-4117
-Original Message-
From: Scott Canaan [SMTP:[EMAIL
ROFLOL
Gosh, we don't know why, must be the databases fault, all 15 of them.
Thanx for giving me a Friday Funny..BOL
Scott Canaan
Tracy,
The best thing you can do to your sanity is to completely ignore these
kinds of ratios. If the wait interface shows a problem you might now and
then end up looking at certain ratios in order to determine the real
reason for waits, but that's it. Ratios as the ones you mention are
Dennis
I want to do sync 4 tables from db1 to db2 and 3tables from db2 to db1.
If i make one server as master server then is it possible to make secondary
server(snapshot server) once and vice versa.
Thanks
-Seema
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple
Yes you could, but one needs to be aware of the security implications. One hopes
that nobody is running their external procedure listener under a privileged user such
as oracle or root.If so who ever could use the PL/SQL procedure could rename
YOU right out of a job.
Ian MacGregor
Diego,
Let me say that v$system_event (and I assume its valid for
v$session_event
too) does not report
the "enqueue" average wait time correctly. (unless until version
8.1.6, I
don't know what version are you using)
I know and I know why that is ;-) And by the way, it is correct ...
Anjo.
Seema -
I have only done just a little testing of replication, so I'm hardly
the expert. I believe the answer to your question is yes. You can make db1
the master site for the 4 tables and db2 the master site for the 3 tables.
The bigger question is whether changes can be made to
Hi Scott/All,
We have been able to identify the root cause for the issues we had with EMC
during the last 2 weeks. The root cause was an issue with EMC PowerPath in a SAN
environment where it was not able to resolve alternate paths. We are upgrading
from PowerPath Version 1.3 to Version 2.0
Of course you could use Perl with the DBI, DBD::Oracle and
Spreadsheet::ParseExcel modules.
I've done it, work great. Load directly from the spreadsheet
into an Oracle table.
Jared
On Thursday 18 April 2002 07:28, Koivu, Lisa wrote:
Or sql*loader. csv isn't the best choice of file format
Storing dates as varchar2 doesn't sound like a good
idea to me, especially in a data warehouse.
All date comparisons will require converting to
date type.
In many cases you probably don't want to stored dates in your data
warehouse anyway. They should be in a robust date dimension
table.
Um, no, not really.
SAPDB is Sybase, pure and simple.
Jared
On Thursday 18 April 2002 12:21, Gordon, Emery {PDBI~Palo Alto} wrote:
There is a new alternative. SAPDB is open source but supported by SAP. Whan
used outside of SAP applications it is free but charged when used inside of
SAP.
This is because the paper is comparing Oracle 7 to SQL Server 2000.
So it is correct, just out dated.
Jared
On Friday 19 April 2002 12:58, Igor Neyman wrote:
LOL!
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
From: Marin Dimitrov
To: Multiple recipients
Power units are history.
You can renew them, but you can't buy more.
It's by CPU or named user per server.
Jared
On Thursday 18 April 2002 14:20, Seefelt, Beth wrote:
I'm not positive, but I'm pretty sure you still pay by power units. a 4
x 200Mhz costs the same as a 1 x 800Mhz.
I agree
Hi gurus,
I created a script to assign some grants automatically to some roles and users.
As the user sys, I assigned to user system the GRANT ANY PRIVILIGE, GRANT ANY ROLE,
roles and when run the script get the error of insufficient privileges.
What I dont want is to connect to each user to
Hi all,
I'm confuse with Segment Header and Data file header.
some said LMT keep the free block information (bitmap) in Segment header and some said
Data file header.
I have 3 questions
1. where oracle keep LMT bitmap each data file header or each segment header ?
2a. if it is store in data
That won't give SYS the privileges you think it does.
For any user, including SYS, to be allowed to grant direct
privileges on another users objects, that user must have
explicity direct grants with the 'with grant option'.
e.g. to allow SYS to grant privileges on the table EMP
owned by
98 matches
Mail list logo