On Fri, 13 Sep 2002 13:08:26 -0800, Dennis Williamswrote:
>You must have a copy of the Oracle RMAN Pocket Reference at your elbow. At
>only $13, it is a steal. Jonathan Gennick who participates on this list
>edited it.
Yes, I did, but please give Darl Kuhn and Scott Schulze some credit
for writi
Nat,
SQL-generating-UNIX commands works well...
select 'dd bs=1024k if='||name||' of=/dev/rX' from v$datafile
union all
select 'dd bs=1024k if='||member||' of=/dev/rX' from v$logfile
union all
select 'dd bs=1024k if='||name||' of=/dev/rX' from v$controlfile;
Spoo
Thomas,
If you rely on the premise that cold backups can only be taken after a
non-abort shutdown, then there is no reason to backup on-line redo
logs. (If you rely on backing up redo because you do cold backups after
shutdown abort, well, then we can have an argument about best
practices.) In
Evening all -
Starting new here in Oracle. I havethis table with a field described as
"Number". I'm trying to move the values in a MSAccess field of type
Double to this Oracle field. Although all the number in the MSAccess
fields are in a domain of 1 ...3 they show up in Oracle as a Zero. I'm
mo
If you are Oracle Applications 11.5, look at the FNDCPASS utility. This allows you to
change
application user passwords from the command line. They have also exposed password
change
functionality in the FND_USER_PK (I think thats the name). You would need to roll
your own
interface into wha
Thanks for responding
I need to change oracle application user's password from within application.
I also need to change same user's W2K/NT domain account password whenever
that user changes their password in oracle application. Hope I am clear
here.
Appreciate your response
and Thanks a ton
Nat - Thanks for taking the time to explain that. As I said, it has been
quite some time since I worked with raw, and at that time the system admin
just gave me a single mount point for the entire device. Best of luck with
your project, sounds like you've planned well, but don't skip that full
bac
I have used Change Management Pack. It helps manage changes when you need
to capture them , especially when moving from Development, to
Certification/UAT and Production. It can reverse engineer existing
databases and schemas, but it does not put the files in a usable format.
The files are in a
Greg:
If the error is coming from DBMS_OUTPUT, then it is probably PL/SQL
related. Try increasing the LARGE_POOL_SIZE parameter in the init.ora
file. I would suggest setting it to at least 2MB. By the way, what are the
shared_pool_size and large_pool_size parameters set to now?
RWB
"Greg
Are you trying to change the Oracle and NT Domain accounts
which are the same and you want the same password ???
If not, write a script or request that one be sent to you.
-Original Message-
Sent: Friday, September 20, 2002 10:31 AM
To: Multiple recipients of list ORACLE-L
Hi All
How
Henry,
I've been looking into something similar at a client. I think you want to
look at external authentication. This will use your OS authentication,
which in turn uses AD. The problem is that OS authentication is not very
secure when using PC clients, so we are using Kerberos as well, which
Try setting the GLOBAL_NAMES parameter in the init.ora file to FALSE for
the target database.
RWB
"Ben" <[EMAIL PROTECTED]>@fatcity.com on 09/20/2002 01:21:34 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTE
We're planning to
revisit change management pack to see whether it's
useful or not.
Versions 2.0 and 2.1 were rejected as buggy and useless.
Is anybody here
using the Change Management Pack and what are the
experiences? Please,
do not use expletives in your replies.
You can spool Oracle output into text files using SQL*Plus. Excel can
handle plain text and Comma Delimitted Text files.
RWB
Bob Robert <[EMAIL PROTECTED]>@fatcity.com on 09/20/2002 03:33:24 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of
By the way, would you use replace to get rid of the commas withiin fields so that Excel reads it properly?
[EMAIL PROTECTED] wrote:
Bob,You can create a CSV file from SQL*Plus with the following statement:select ||','||from where <..>;Dick GouletReply Separa
Title: RE: Spool Oracle Tables into Excel Format
There were some posts recently suggesting the spooling of the columns using a comma as a separator. But check out this article in XML Journal (http://www.syntelinc.com/syntel/english/0072/SYNT_XMLjrnl.pdf). It shows how to build preformat
Hi All!
We get ora-04031 on Oracle816 on Unix.
I'm aware that this is a bug about memory leak and we planing upgrade to Oracle 8173
to fix it.
In a mean time I increased the shared_pool and shared_pool_reserved_size , and also
ping some packages in.
Now error sad that: enable to allocate 4096
Sure. Use ',' as colsep, and have file extension csv.
Jun
-Original Message-
Sent: Friday, September 20, 2002 4:33 PM
To: Multiple recipients of list ORACLE-L
All,
Is it possible to create Oracle reports into Excel
format ?
Is it possible to spool Oracle tables into Excel
format?
Tha
Bob,
You can create a CSV file from SQL*Plus with the following statement:
select ||','||
from
where <..>;
Dick Goulet
Reply Separator
Author: Bob Robert <[EMAIL PROTECTED]>
Date: 9/20/2002 12:33 PM
All,
Is it possible to
Another option is to shutdown db, backup the files to tape, remove filesystems, create
symbolic links named the same as your datafile names linked to the raw devices,
restore files to symbolic links (i.e. raw devices), startup db. Just a thought.
Gene
>>> [EMAIL PROTECTED] 09/20/02 04:20PM >>
Dennis,
Absolutely, I agree. Perl is very handy and easy to learn..., You could use
awk also on unix, pretty nifty stuff...
To answer to your situation where the REASON line could be more than
one/two/three or n lines- Yes, you could use CONTINUEIF.
It provides a comparison operators (= and !
All,
Is it possible to create Oracle reports into Excel
format ?
Is it possible to spool Oracle tables into Excel
format?
Thanks in Advance
Bob
__
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
--
Please see the of
Title: RE: PL/SQL help
Go to Tom Kyte's sight and look for contexts - he explains a way to build sql statements using native dynamic sql and refcursors and contexts where the select statement and predicate is variable and the output might also be variable. I get there by searching www.yahoo.c
Denis,
Sorry I missed your main question last time. Each datafile in our database
will represent a separate raw device. so question of overwriting files will
never come. If I have 30 datafiles in 5 files systems, I will be creating
30 raw devices with properly sized devices to match my datafile
Thanks, Jan.
Are you still at work?
--Walt (1.85254E-16ly tall) Weaver
-Original Message-
Sent: Friday, September 20, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L
DBA/Developer/
7.0
JP
On Friday 20 September 2002 20:29, you wrote:
> Jan,
>
> Which version of PostgrSQL are y
David,
I don't know sqlldr that well, but a possible quick and dirty solution -
is to load the text file into a one column oracle table, and then in a
subsequent step, use SQL to move the data to the proper columns of the
proper Oracle table. The ctl file from the first step would be something
l
Just keep in mind that you can not offline system tablespace ;)
- Kirti
-Original Message-
Sent: Friday, September 20, 2002 2:44 PM
To: Multiple recipients of list ORACLE-L
Nat - I think your process looks fine, bearing in mind that I haven't used
raw devices in years. Others on the l
Viral - I'm glad that someone a lot more familiar than I with SQL*Loader
replied, and hopefully that will handle David's problem. I'm just curious
about one thing, having encountered this sort of thing before. Can
SQL*Loader handle the situation where some lines may not be present? For
example, su
7.0
JP
On Friday 20 September 2002 20:29, you wrote:
> Jan,
>
> Which version of PostgrSQL are you using?
>
> --Walt Weaver
> Bozeman, Montana
>
> -Original Message-
> Sent: Friday, September 20, 2002 11:35 AM
> To: Multiple recipients of list ORACLE-L
> DBA/Developer/
>
>
> We are usi
Nat - I think your process looks fine, bearing in mind that I haven't used
raw devices in years. Others on the list use raw on a daily basis, so may
offer some suggestions.
My question was much simpler. Suppose I have a 80-gig. device, and a
20-gig. datafile. Okay, my recollection is that I ca
I would change to the following:
>>> [EMAIL PROTECTED] 09/20/02 03:09PM >>>
Dennis,
We are thinking of doing following steps for our RAW conversions.
Let me know whether it makes sense,
1. Shutdown Database.
2. Take Full Backup
3. Setup all our raw devices ( properly corresponding to our origin
Oracle sql*loader has many many features...at two of them are applicable in
your specific case.
You could use CONCATENATE or CONTINUEIF clauses of control file. These
clauses help you wherever you have multiple physical records form one
logical record.
Cheers
Viral Desai.
>From: DENNIS WIL
John, seeing as your e-mail name is "Ora NT DBA", you probably should have
qualified your reply with "as long as the DB is down". Backing up live
Oracle files on Windows (even NTFS) is a recipe for disaster due to locking
problems (with the OS/filesystem or the backup software, I'm not sure). We
Alan Davey wrote:
>
> In any given SQL statement, do I need (or should I :^) ) create a bind variable for
>every literal value even if it is one of the following cases:
>
> 1) substring in a substr function
> 2) date/time format mask used in to_char or to_date function
> 3) comparison value
Nat
Just a plug for always testing your backups, regardless of whether you
are doing hot or cold. We do cold backups, and we test them from time to
time by restoring them on a test system so the developers have some data to
test against. Several times over the years we've found that a file was
Title: RE: count(*)
Hmmm ... everyone is throwing their ideas around ... so here is mine ...
Hopefully on this large table you have a PK.
1. First time when you do the count(*) (I hope it will be > 10 minutes), do it as follows ...
select count(*), max(pk_column)
from my ludicrously_larg
Dennis,
We are thinking of doing following steps for our RAW conversions.
Let me know whether it makes sense,
1. Shutdown Database.
2. Take Full Backup
3. Setup all our raw devices ( properly corresponding to our original
filesystem datafiles.)
4. Bring up the database in restricted mode.
4. Bri
I think maintaining counts in other table (Naveen's approach) is more of an
application issue. To avoid multiple processes waiting for a lock to update
records in seperate table, you could have each process its dedicated row in
a seperate table with the current count in it. A slight modified ve
Title: RE: Another Case Insensitive Question
Julie,
Get a copy of Find and Replace by Rick Fisher. The url is below. With it you CAN change all those queries and reports in the Access FE. It's one of the best $37 an Access developer can spend.
http://www.rickworld.com/products.html
You
I agree, there is never a problem because you backed up redo log files.
There could
be a problem with inadvertently restoring them, covering up needed information
in the
current online redo logs.
John
[EMAIL PROTECTED] wrote:
My long standing position on this is that you take backups so
On our larger database we do exports of some of the smaller users which also
have frequent changes.
I wish I had some of the larger tables also, it would have saved a big
headache last week getting one table restored (7 days to get the files
restored from tape, 1.5 hours to modify the control tr
Jan,
Which version of PostgrSQL are you using?
--Walt Weaver
Bozeman, Montana
-Original Message-
Sent: Friday, September 20, 2002 11:35 AM
To: Multiple recipients of list ORACLE-L
DBA/Developer/
We are using PostgreSQL, but still have problems with statistics.
Sometimes after VACUUM
Hi
Well my import choked on SYS.DBMS_REPCAT_UTL so I just assumed
that there was SYS schema stuff in the full export. I see now that
the import must execute this package. This package was having a
problem with the fact that the exported global name did not match that of
the instance I was import
Hi
Well my import choked on the package SYS.DBMS_REPCAT_UTL so
I assumed that there was SYS stuff in the full export.
-Original Message-
Gopalakrishnan
Sent: September 19, 2002 3:43 PM
To: Multiple recipients of list ORACLE-L
Export program **never** exports the contents
of SYS. WH
Well I just happen to know of this great Oracle Press RMAN book due out in
October!
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
The avalanche has begun, It is too late for the pebbles
My long standing position on this is that you take backups so that Just in
case something fails, you have the ability to recover. If something has
failed, I want backups of EVERYTHING. I know I dont' need the redo logs,
but I would feel awful silly if I needed them at some point but didn't back
David-
I've thought of both dbms_sql and dummy conditions too. Oracle Application reports
use the dummy
conditions all the time.
I'm off to see if you can set cursor_sharing at the session level and not use bind
params.
I'm assuming no one else has figured this out either due to the lack of
Hello Everyone,
Access 2000 on Windows NT
Oracle 8.1.7.4.0 on HP-UX 11.0 64-bit
Currently both the front end and back end are in Access 2000 and we are
moving the back end to Oracle.
I've got a situation here I'm not sure how to deal with. Does anyone know
how to do case insensitive queries usi
No we do trust our hot backups. Our databases are mostly idle during early
ours of Sunday between 12 AM - 1 AM.
So we thought lets go for a cold backup on weekends.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 20, 2002 12:28 P
Ah, that makes much more sense to me. That's more the idea I had in
mind when I installed STATSPACK. That, and the ability to be able to look
back in time to potentially see why our nightly jobs are still running at
8:00 AM. (insert system-stats-vs-session-stats argument here) :)
Thanks, D
Do you really need it?
In case of huge DELETE statement you can always recreate sequence with START
WITH .
JP
On Friday 20 September 2002 19:04, you wrote:
> but sequences cannot be decremented by PREVVAL too, what about DELETIONS?!
>
> -Original Message-
> Sent: Friday, September 20, 2
Naveen,
Please read all the posts. That is the first question I asked.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, September 20, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L
but sequences cannot be decremented by PREVVAL too, what about DEL
We are using PostgreSQL, but still have problems with statistics.
Sometimes after VACUUM ANALYZE optimizer doesn't use indexes
and performance goes down.
JP
On Friday 20 September 2002 18:43, you wrote:
> Ditto for PostgreSQL. For portability you can create a dual table but you
> have to ensure
Hi All
How can I change passwords of a user of Oracle application as well as W2K/NT
Login? Any utility in 8/8i can do this form me?
Thanks in Advance
Shiva B
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Baswannappa, Shiva
INET: [EMAIL PROTECTED]
Fat City Networ
On Fri, 20 Sep 2002, Nat wrote:
> We use EMC/EDM bcv splits to do a hot backup every night. We shutdown our
> database once a week for half an hour for cold bcv splits. So far it has
> worked very well.
Just curious, why do you do a cold backup weekly? Do you not trust
your hot backups?
--
Jer
Naveen,
Why NOT take the redo log files in a cold backup?
If you restore these cold backup files and intend to use them, you would
then have to open the database with the RESET LOGS option to re-create the
redo logs.
This would then invalidate all of your archive log files.
And Joe - thanks!
Naveen - This approach would probably work fine as long as only a single
process was running. If multiple processes were inserting rows (likely at
the scale of millions of rows/hour), this new table would probably be the
bottleneck. Each process must acquire a lock on this row of this table, so
th
exactly, what I meant :-)
just today I had to deal with the stupid SQL Server problem: once in a while
it cannot find a stored procedure on the server, that nobody touches, and
then (in 5min) it finds it - no problem.
yes I'm lucky to work with both Oracle and SQL Server :-) (the second was
not my
but sequences cannot be decremented by PREVVAL too, what about DELETIONS?!
-Original Message-
Sent: Friday, September 20, 2002 8:23 PM
To: Multiple recipients of list ORACLE-L
this is what Oracle invented SEQUENCES for! :)
Tom Mercadante
Oracle Certified Professional
-Original M
I think Dummy is a MS synonym
April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out. _Anonymous
-Original Message-
Sent: Friday, September 20, 2002 11:13 AM
To: Multiple recipients of list ORACLE-L
I think "DUMMY" is M
Robert
I don't think a full export has a place since your largest tables are
probably too large to reimport in a reasonable amount of time. I like Jay's
suggestion though. But your original question wasn't about a full export,
you just said export. My answer is a definite "yes". Following Paret
Ditto for PostgreSQL. For portability you can create a dual table but you
have to ensure that it only has one row. ;-) I finding that portability
between PostgreSQL and Oracle is easier than most... same to_date, to_char
functions, and stuff. Seems like that's part of Postgres' strategy.
-
David - If the file is in just the format you show, my first impulse would
be to use the perl script language to get it into a form that sqlldr could
easily read. Perl is available on all platforms, including Windows. If you
get ambitious, Perl can even directly insert the values into Oracle. Jare
Nat - I haven't worked with raw for a few years, but from my dim
recollection, since you are managing what is on the device, first the system
administrator had to tell me how many blocks I could write to. I also dimly
recall the AIX issue, but certainly couldn't recall the answer. Anyway, this
mea
Title: RE: count(*)
That is the best advice yet. Duh for the rest of us.
-Original Message-
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 10:53 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: count(*)
this is what Oracle invent
Nat-
You may want to check out a product from Veritas.. *Supposedly* their
clustered file system product is *approved* with 9i RAC on a SUN platform..
This is strictly from the rumor mill and I have no solid documentation to
confirm (CYA).
I am actually in the beginning phases of a project to bu
I have a text file and need to load it into database table using sqlldr
utility. Is there a way to load a text file? I know how to load csv file
but not text file.
*** Below is text file format.
Date: Wed Aug 29 10:43:53 CDT 2001
Name: Paris By Night
Email: [EMAIL PROTECTED]
Phone: 202-333-444
I think "DUMMY" is MS reserved word :-)
And yes,
SELECT CHAR(33) -- no semicolon
will work.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 20, 2002 11:18 AM
So Oracle statement S
It is a reserve word but has no purpose that I can find. I'll dig
deeper
-Original Message-
Sent: Friday, September 20, 2002 10:34 AM
To: Multiple recipients of list ORACLE-L
ARE YOU AN IDIOT?
But MS SQL has DUMMY. I don't know why {if they don't have DUAL). Maybe it'
In any given SQL statement, do I need (or should I :^) ) create a bind variable for
every literal value even if it is one of the following cases:
1) substring in a substr function
2) date/time format mask used in to_char or to_date function
3) comparison value in a decode/case statement (not
An export with data will probably cause more headaches than it solves in
large DBs.
A logical export without data will also have limited use. It is quick to do
and small but I suggest may be invaluable for various tasks.
Mike Jenner
Database Administrator
-Original Message-
Sent: 20 Se
There is a difference between 10 and 120 minutes, especially on Friday.
> -Original Message-
> From: Anjo Kolk [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 20, 2002 3:03 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: count(*)
>
>
> If you can live with 10 minutes,
As well as in MySQL
>There is no need for such table in SQL Server.
>If you need, you do just:
>
>select 'whatever'
>
>without "from" clause.
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Au
I'm not an expert so pardon me if i'm wrong.
Why to copy the log files in case of a cold backup if the instance was
shutdown cleanly(NOT ABORT)??
The d/b will be consistent so we don't need the redo-log files, isn't it?
Isn't it that the DB update all the Datafiles headers with the checkpoint
in
Robert - My info:
Oracle 8.1.7 E.E.
Largest DB is 900gb
Hot Backups 2x week
Cold Backups 1x month
Export Backups 1x week on selective schemas
I do export backups for creation of test db's, recover data validation blunders, i.e.
single object restores.
Future plans are RMAN, RMAN, RMAN on 9i.
Robert - Maybe this argues for the book being really, really good, if a
publisher decided to release it at this stage. If anyone has a chance to
browse it, I would be interested. Say Robert, as a noted author maybe you
could get your publisher to request a complimentary professional review
copy??
Title: RE: migrated from 8.1.5 to 8.1.7 and Migration Assistant moved my
i had the same issue where all my data files were moved to the same slice
which fortunately i had a large slice. i ended up doing the manual upgrade
steps through the Migration manual.
-Original Message-
From:
Nat, totally understand.
joe
Nat wrote:
>Joe,
>
>We are planning to move to RAC. Per Oracle RAW devices is must for RAC.
>As you said, Yes there is little performance gain just moving to RAC and
>more work to DBA's/SA's.
>But this seems to be the main requirement for RAC.
>
>
>- Original
Thanks.
I tried it and it works, but I was not sure if it is right or not.
JP
On Friday 20 September 2002 16:18, you wrote:
> Jan,
>
> There is no need for such table in SQL Server.
> If you need, you do just:
>
> select 'whatever'
>
> without "from" clause.
>
> Igor Neyman, OCP DBA
> [EMAIL PRO
ARE YOU AN IDIOT?
But MS SQL has DUMMY. I don't know why {if they don't have DUAL). Maybe it's a
future feature in case MS will buy Larry's child :-))
JP
On Friday 20 September 2002 16:08, you wrote:
> Hallo,
>
> What is dual? ;o)
>
> I don't think there is such a beast in SQL Server
>
> Dave
Our db size is around 350Gig. We have stopped full logical exports since
our database size has grown above 200 Gigs.
It is just not feasible for us to do the full exports anymore, time it takes
to export is too much.
We use EMC/EDM bcv splits to do a hot backup every night. We shutdown our
data
So Oracle statement SELECT TO_CHAR(33) FROM DUAL
is in TSQL only
SELECT CHAR(33); ?
I was searching docs, but didn't find it. I know on Sybase SQL Anywhere is it
DUMMY, but it doesn't work on MSSQL (and DUMMY is on MS SQL reserved word!!)
JP
On Friday 20 September 2002 16:18, you wrot
I do nightly exports of my large databases with ROWS=N. This way I can restore users,
grants, indexes, table definitions, etc.
Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA
>>> [EMAIL PROTECTED] 09/20/02 10:13AM >>>
I'd like to pose a question to you all and get your respo
Tom -
actually, the SQLPlus like thingie in sybase/m$ land is called isql
(interactive sql). T SQL is the SQL dialect understood by those RDBMSs. so
you type yout T SQL queries into isql.
-Original Message-
Sent: Friday, September 20, 2002 9:24 AM
To: Multiple recipients of list ORACL
this is what Oracle invented SEQUENCES for! :)
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, September 20, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L
What about having a separate table with a single column and a single row to
store only the
Title: RE: Query Tool That Reads LOBs, CLOBs, etc.
I think latest version of TORA and TOAD can read it.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and
If sales from my Mastering Oracle8i book are any indication, the market for
8i specific books is long gone. :-( I'm thinking that the 9i specific book
market will probably start to slow down (if it hasn't already) pretty soon.
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midti
Joe,
We are planning to move to RAC. Per Oracle RAW devices is must for RAC.
As you said, Yes there is little performance gain just moving to RAC and
more work to DBA's/SA's.
But this seems to be the main requirement for RAC.
- Original Message -
To: "Multiple recipients of list ORACL
We have a development project that is using third
party software. The tables include several clob
datatypes. The project needs to identify a tool that
allows a knowledgeable user can use to browse data in
the CLOBs.
Does anyone have any suggestions of tools to do this?
Thanks,
=
Pete Ba
When I upgraded and migrated from 8.1.5 to 8.1.7 the Universal
Installer/Migration Assistant moved my $ORACLE_BASE from /disk03/app/oracle
to /disk03/app/oracle/product/8.1.5 (which is my $ORACLE_HOME) without
prompting me for the move.
SD
-Original Message-
Sent: Friday, September 20, 2
there is no such beast as DUAL in MS SQLServer. if what you want is the
result of a function just leave off the from clause like so:
select getdate()
-Original Message-
Sent: Friday, September 20, 2002 8:43 AM
To: Multiple recipients of list ORACLE-L
Does anybody know what table is in
Robert,
I don't do exports of our large production systems mainly due to the fact
that I'd have to export them to tape and getting that much quite time, so as not
to bump in to an ORA-01555 or have someone else hit a rollback segment issue, is
impossible. Consequently two hot backups a week
JT.,
Do you have any awareness of www.ORAFAQ.com Oracle-job.net?
Thanx,
Bill
--- Joe Testa <[EMAIL PROTECTED]> wrote:
> Bill I'm kinda surprised no one has replied. I'm seeing
> pockets of
> oracle work in cols most of it is short-term(ie: < 3 months).
>
> This is the best place to find wha
Jan,
There is no need for such table in SQL Server.
If you need, you do just:
select 'whatever'
without "from" clause.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 20, 2002 9:43
Do you have a service like Oracle_HOMETNSListener?
I assume that you must. You don't need a separate listener for each
instance. What does the TNSNames.ora entry for LMANAGER look like?
Tom,
The sequences are transaction independant, so the trick with 'select
sequence_name,last_number from user_sequences' will only work if there are
no rollbacks after insert as well as no use of cache in sequence as you
mentioned.
Moreover, what if records get deleted? I guess this may be solved
Jan Pruner wrote:
>Does anybody know what table is in MS SQL instead of Oracle DUAL?
>
>Thanks
>JP
>
SQL Server does not have a dual table, pos...
--
"Give a man a fish and he eats for a day, show a man the net and he'll be
preoccupied for month's."
--
Please see the official ORACLE-
Mark,
Thanks for the reply. We are on AIX 4.3.
We are not changing hardware when we move on to RAW devices. Our entire
hardware is going to remain same.
We feel dd is the fastest method of copying the files. But we need to figure
out how many blocks
we should skip in raw devices.(point 2 in NOTES
Now I know. I assume that it's enough like SQLPlus that it seems familiar
and different enough that you can really foul yourself up.
"Farnsworth,
Dennis,
Thanks for the reply. We have not done any benchmarks to find out if there
is any performance
gain. The main reason for moving to raw devices is to convert our existing
database to function on OPS
environment and then eventually to 9i RAC.
After we move on to raw (without OPS), may be I
1 - 100 of 121 matches
Mail list logo
