Hi
Start RMAN from BoxA binaries?
Jack
Ross Collado
Hi
Ignore previous post!
Jack
Ross Collado
hi!
from my experience of haveing the same data or data model
on different DB brands and platforms it is wise wiser wisest
- cause you never know what the management is going to
buy next - to stick to the following naming conventions
for identifiers:
+ all identifiers in uppercase
+ not more
hi!
anyone knows an answer to this:
i want to user JDBC thin driver. i can install it from the
CD on windows using the manually configured installation.
since thin driver is said to be purely java, i want to use
it on linux, too. which are the necessary files?
are they in
Hi everyone
I might sound like I am a bit crazy or something, but here is my
problem. There is a customer who is having a problem when he tries to
open his report from application, which is running on ORACLE DATABASE.
The message he gets is about a Wormy-1 virus, he wants me to check or
scan the
i am sorry i have to give another reply to the
WINDOWS issue, quoting also a cultural superior american
named frank zappa
--
all that we got here's american made
it's a little bit cheesy, but it's nicely displayed
well we don't get excited
tell the user that he must ALSO scan his PC for viruses while you check
the database. Then wait for him to find it on his PC... and do nothing
because the problem is on his side, not the database.
you can also look up wormy-1 on the symantec site and send the user the
information about the virus
Did you check the registry on the machine that you execute sqlplus on to see
if there is nls_date_format there?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 7:38 AM
Hi,
The default date format for an
Hi,
On the DB side, i see only the possibility of having infected docs in
blob columns. I have once loaded such a document, and client (me,
fortunately) was alerted each time while retrieving that document via a
browser. As a matter of fact, I had no antivirus on the server, i
suppose it would
Ross,
when you say RMAN backups are initiated from BoxA to backup db in BoxB
what do you mean? are they run on BoxA or BoxB? If they are run on BoxA,
then the backup files will be created on BoxA.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, July
I checked my Registry..
Nls_date_format is not set in the registry..
-Original Message-
From: Yechiel Adar [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 5:18 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: how to change nls date format.
Did you check
Yes. You can do that when you are creating an instance, define the parameter
nls_date_format in the init.ora file as per your requirement, then the
nls_date_format for the Instance would be as supplied by you.
Alter Session/Alter System would do the same at the time so defined.
Vikas Khanna
How can I do to sqlloader work faster.
I tryed the DIRECT option, same result.
I tryed DIRECT and PARALLEL option, same result
I am working with an Oralce 8.1.6.3.0 patched sqlloader
I loaded 20 000 lines in 1 minute and I wish to load 400 000 lines in the
same time?
--
Please see the
Ross
No.
The fundamental way RMAN works is to create the backupset on the target
system.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 30, 2002 12:58 AM
To: Multiple recipients of list ORACLE-L
Hi all,
Env.: 2 Solaris boxes both
Vivek
Here is a search string that should work. The list server will probably
break it into two pieces, so you'll have to patch it back together. Good
luck on your project.
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA1
Jisbn=007222360X
Dennis Williams
DBA
One of our developers wants to create a reusable report where the
pipe-delimited output generated by SQL*Plus would be sent off and used as
input into another process. The problem is the remarks field which is of
type long. It causes ORA-00997 errors. If I take the pipe-delimits off,
the
When people pass exams they tend to say the exam was easy.
When they fail the exam they tend to say either I didn't study enough or
It was hard, that one!
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology
The one way is to mount the directory from one box to another using nfs.
Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 3:23 PM
Ross
No.
The fundamental way RMAN works is to create the backupset on the
Hi,
Network performance could be a bottleneck.
Do you run loader from server or from remote host?
Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 2:58 PM
How can I do to sqlloader work faster.
I tryed the DIRECT
U can set the Buffer size to increase the work faster
-Original Message-
Sent: Tuesday, July 30, 2002 6:29 PM
To: Multiple recipients of list ORACLE-L
How can I do to sqlloader work faster.
I tryed the DIRECT option, same result.
I tryed DIRECT and PARALLEL option, same result
I am
Gilbert,
disable or remove all constraints on the table being loaded.
remove all indexes on the table being loaded.
if all else fails, buy a faster machine with faster disk.
good luck!
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, July 30, 2002 8:59
Leslie:
Please look at www.oaug.org as this is the web site for the Oracle
Applications User Group. You can join their list serve as well.
As far as your installation issues,
1. You should install the demo environment as is and do not modify anything.
It takes approximately 6GB to install.
Oracle's politic is to make us using GUI tools. This is reflected in OCP
exams, so I can conclude that for newbies exams become easier while hardcore
DBAs might never use GUI tools.
Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday,
See Oracle SQ Loader - The definitive guide by Jonathan Gennick
Amazon URL is
http://www.amazon.com/exec/obidos/ASIN/1565929489/qid%3D1028034789/sr%3D11-1
/ref%3Dsr%5F11%5F1/104-2680480-7921519#product-details
Also there is a good review (and examples) by a member of this list -
Stephen Andert
Gilbert - Have you looked at:
http://www.orafaq.com/faqloadr.htm#SPEED
Are you saying that performance with and without direct produced the same
time? There were some good suggestions on the list yesterday, I recall, but
I didn't keep them.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
Title: RE: How to use pipe-delimited SQL*Plus output with a long datatype
Cherie,
Did you try a set long to some value to see if that would work? set long 2000
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 9:23 AM
To: Multiple
I have a developer using SQLNavigator and getting the following error while
trying to recompile some code.
ORA-04021: timeout occurred while waiting to lock object. This developer is
the only one in the database.
The database has been 'bounced' to clear all locks but the error still
occurs.
I think the problem is that you can't do an operation (like concatenate) on
a long field.
But another way to get the same output is to set colsep '|' , and then use
plain old select list
chaim
[EMAIL PROTECTED]@fatcity.com on 07/30/2002 09:23:20 AM
Please respond to [EMAIL PROTECTED]
Sent
u can write a cursor.
or u want the o/p in 1 select statement
rgds,
Ams.
www.medicomsoft.com
|-Original Message-
|From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
|karthikeyan
|S
|Sent: Monday, July 29, 2002 6:08 PM
|To: Multiple recipients of list ORACLE-L
|Subject:
From server,
I put the table in nologging and I improve the loading by 84%.
Now I am at 400 000 lines in 3 minutes and I wish 400 000 in less then 1
minutes.
I do not have any trigger, index, constraintes or foreigh key.
Any more about
Thanks.
-Message d'origine-
De:
Ron,
When exactly this happens?
Could be running pl/sql procedure and trying do something with itself or
with calling procedure (like grant execute, for example)
Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 4:48
just put the zip file on your path
On Tue, 30 Jul 2002, Daniel Wisser wrote:
hi!
anyone knows an answer to this:
i want to user JDBC thin driver. i can install it from the
CD on windows using the manually configured installation.
since thin driver is said to be purely java, i want to
Yes, i seem to recall whilst on the crashes, dumps and corruptions seminar
that it was mentioned that Oracle are moving away from command line tools in
favour of GUI tools in much the same way that server manager is no longer
available - does anyone know if this is truly the case? Will command
Due to probs with e-mail servers I missed digests 204 - 207 inclusive from
Oracle-L. Any chance someone subscribed digest mode with a back catalog ;)
could send them on to me please?.
It's a bit too slow to review all via web page.
-
Seán O' Neill
Organon (Ireland) Ltd.
Title: Dynamic SQL problem (Oracle 9-8)
Hello,
I have software compiled in Oracle 9 environment. And when I try to fetch data using
different versions of Oracle client/server I receive ORA-errors:
1. client 9 -- server 8: ORA-00932: inconsistent datatypes
2. client 8 -- server 9:
Hi,
I am facing the following problem while importing a .dmp file (from a tape) into
solaris 8 server.
Oracle : 8.1.7
I am getting the following error while using the IMP command.
Invalid format of import utility name
Verify that oracle_home is properly set
Any help regarding this is
Maybe partitioning on several disks?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 4:54 PM
From server,
I put the table in nologging and I improve the loading by 84%.
Now I am at 400 000 lines in 3 minutes and I wish 400
The developer has the object opened for update in SQLNqvigator. When he
tries to compile and save it,
he gets the error.
Ron
-Original Message-
Sent: Tuesday, July 30, 2002 10:13 AM
To: Multiple recipients of list ORACLE-L
Ron,
When exactly this happens?
Could be running pl/sql
Ethan,
Consider performing the clone in 2 distinct phases (my SOP). 1) Copying the
source database to the target machine w/ recovery if necessary, and 2)
Renaming/recreating the controlfile.
The recovery can be against a hot backup copy or cold w/ a controlfile
backup, and assures one of having
Did you do a
SET ORACLE_SID=my_importDBName
before issuing the IMP command?
Dave
-Original Message-
Sent: Tuesday, July 30, 2002 10:20 AM
To: Multiple recipients of list ORACLE-L
Hi,
I am facing the following problem while importing a .dmp file (from a tape) into
solaris 8 server.
I don't know the answer to your question. But I prefer the command line.
You know exactly what is going on whereas with GUI tools you don't know what
is going on behind the scenes. Most Unix admin people I know also prefer
the command line.
My 0.02 Euros worth,
Ken Janusz, CPIM
-
Here's an excerpt from the documentation:
When deploying a Forms application on the Web, the icon files in ICO format
specified for an iconic button, a menu, or a window) are not used. The only
file formats accessible through the Web are GIF or JPG files (GIF is the
default format). By default,
Hi All -
We have a small application that was written in Foxbase under DOS. While it
runs fairly well most of the time, the management wants to migrate it to a
windows-based application. We are open to any mainstream application and
database solutions at this point, although our budget is very
On 28 Jul 2002 at 19:33, Michael Kline wrote:
There are a lot of
stable production windows server systems. Not as good Unix,
but it doesn't have to be.
Oh, there are? I've also heard that legend, but after having an
Exchange server down
last week for almost a day, I stopped
John,
I have been discussing this with a colleague and our question is - what are
you hoping to achieve?
If you are using a spfileSID.ora file then that will be used every time you
startup so in what circumstances would you use the pfile?
PS one suggestion re the problem creating the trigger is
Do you have nls_language parameter specified in your init.ora file?
I think, Oracle will not pick up the value for nls_date_format from
init.ora unless you have nls_language specified in it.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list
Title: RE: Creating a **DEFAULT** database
The same thing is not required on Sun Solaris. On Solaris 'user1' still belongs
to a different unix group.
I have an user on both DG-UX and HP-UX which is not in the 'dba' group. Connection (internal or tcpip) works fine on both systems
Not sure if Oracle provides one, but another solution is available here:
http://www.kumaran.com/xbaseconverter.asp
If it is such a small app though - why not just stick it in (dare I say
this) something like Access or SQLServer..
-Original Message-
[EMAIL PROTECTED]
Sent: 30 July 2002
GUI tools are simply a front-end presentation layer for SQL commands. GUI
tools do not bypass the SQL command-line layer; they only abstract it.
Command-line tools (such as SQL*Plus) use the same API as the GUI tools, but
simply do a lot less abstraction on the presentation. Command-line tools
Has anyone been able to install/use the DBD::Oracle Perlmod with only the
JDBC thin driver? I keep nabbing .h files and .mk files from other boxes,
then trying to re-install, but I haven't had much luck yet.
Jared, this would be a great free chapter from your new book! ;) (I'll
buy it
...hardcore DBAs might never use GUI tools.
I fit that category. :)
Gaja Vaidyanatha has recently moved to Oracle, and server tools
are now his responsibility.
I challenged him to turn OEM into something I would actually
be willing to use. :)
Jared
Alexandre Gorbatchev [EMAIL
So how do I get into the archives? I've got a question I know I've seen
answered.
Thanks,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services
I am doing some performance monitoring on an 8.1.7 DB on Windoze. I ran the following
query;
SQL select name,value
2 from v$sysstat
3 where name = 'redo log space requests';
NAME VALUE
Jesse,
Enlighten me as to why DBD::Oracle cares which JDBC driver you use.
Jared
Jesse, Rich [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/30/2002 09:38 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
Thanks all who replied.
I agree that for this app SQL Server might be more suitable. My main
concern is the application code that enforces business logic. How do we
migrate the source code into the new application without re-rewriting? I
will definitely look into the tool recommended by Mike.
Title: RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
...hardcore DBAs might never use GUI tools.
I fit that category. :)
What about the OUI? Don't you use that? :)
Dan.
I fit that category as well. I talked to him last night he's gonna
try :)
--- [EMAIL PROTECTED] wrote:
...hardcore DBAs might never use GUI tools.
I fit that category. :)
Gaja Vaidyanatha has recently moved to Oracle, and server tools
are now his responsibility.
I challenged
John - I've noticed that Google queries pull up info from the archives.
Obviously you'll get other stuff, but if you can make your query pretty
specific it may get you what you need.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 30, 2002
Being a hardcore SQL*Plus hacker as well I was amazed
to find a freebie on the net that I actually liked and
used. It will work with any JDBC accessible database
(being written itself in java). All you have to do is
load your JDBC driver of choice. It also provides a
panel for entering SQL
Tim:
I take exception to the age thing here. Yes, I remember rewriting the MVS
procs for Oracle's MVS implementation because they never checked to see if
MPM was running in the background task manager of SDSF. Add to it that I
wrote (helped Oracle) a complete TSO Dialog Manager interface to
Thanks everyone for your kind help, advise and hints.
I finally got it working with gnuplot.
I had to make some changes to my code, but this is how it works.
1. Every 10 minutes MS task scheduler wakes up and executes a CMD file.
2. This CMD file
a. Executes a SQL script that generates a
Dennis:
Foxbase was originally called 10-base before Fox Systems change the name.
Foxbase was changed to FoxPro and then purchased by Microsoft and called
Microsoft FoxPro, and then Microsoft Visual FoxPro. I would highly
recommend investigating the MSFT solution. Sorry guys, but this is a
Leslie Lu wrote:
Hi all,
I purchased the Oracle 11i Release 5 (with 11.5.6
family packs) CD pack for Windows from Oracle online
store.
My first installed (Win2000) run out of space, and I
cleaned the folders manually. When I got more space
and installed again, I got:
not all
Thanks to those who recommended the relatively new set colsep command. It
did work in this report.
Thanks again,
Cherie Machler
Oracle DBA
Gelco Information Network
I have a request from one of our developers to create two new sequences on
the DUAL table.
This seems like a bad idea to me. I've never had such a request in the
past. I asked for clarification on why this is needed and I didn't get a
lot of details yet.
Is this something that is standard
Snip
The functionality for Server Manager command-line was migrated in it's
entirety into SQL*Plus (near as I can tell, including ORADEBUG), so Oracle
eliminated svrmgrl not so much as a way of deprecating command-line
utilities in general, but rather to consolidate redundant products...
/snip
FYI,
While looking for db comparisons I found a site that has a few:
http://www.itsystems.lv/gints/compare_db.htm
Note that it is located in Latvia.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
More than the number of time you are waiting for 'redo log space requests'
its more important to find out how long you are waiting for that. 27 times
out of a million might not be a big deal for you to tune.
having said that, here is a posting by Steve Adams on this topic
Q : Every day our
If anyone can... he might be able to.
-Original Message-
Sent: Tuesday, July 30, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L
I fit that category as well. I talked to him last night he's gonna
try :)
--- [EMAIL PROTECTED] wrote:
...hardcore DBAs might never use GUI
My assumption is that (everything else equal) *nix on a PC
server is a superior technology, more performant, more stable.
Unfortunately one has to know a lot more low level tech stuff
to get into the *nix game than is the case with windows, and
therefore *nix on a PC will remain to a
Make sure that it is in your class path aswell.
Alex [EMAIL PROTECTED] wrote:
just put the zip file on your pathOn Tue, 30 Jul 2002, Daniel Wisser wrote: hi! anyone knows an answer to this: i want to user JDBC thin driver. i can install it from the CD on windows using the manually configured
Dennis,
While I hate doing this on an Oracle list, you might want to consider SAP DB
considering your limited budget and requirements. The general product
details are here: http://www.sapdb.org/ and you can request a free CD here:
http://www.sapdb.org/sap_db_cd.htm.
Quite impressive and
Title: RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
I'd like to add another free gui thats kind of neat, DataBee DBATool utility.
You can find it at http://www.databee.com
-Rich
-Original Message-
From: Bill Pass [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July
Visual FoxPro has an upsize wizard that can go directly to Oracle. It would
still be a lot cheaper to keep it in FoxPro over the cost of Oracle.
-Original Message-
Sent: Tuesday, July 30, 2002 12:45 PM
To: Multiple recipients of list ORACLE-L
Dennis:
Foxbase was originally called
H? Sequences are not created on the dual table. Sequences exist as independent
entities. Ofttimes, sequence values are selected using the dual table (e.g., select
seqname.nextval from dual) -- this is a coding choice. Performance of queries that
select from the dual table are generally
I can't find it in the docs either.
Info at ixora.com suggests setting LOG_BUFFER to a multiple of the log block
size.
http://www.ixora.com.au/tips/tuning/log_buffer_size.htm
This next link explains what a log block size is:
http://www.ixora.com.au/notes/log_block_size.htm
Have fun!
Ed
Title: RE: Creating sequences on the DUAL table?
answer below
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
I have a request from one of our developers to create two new
sequences on
the DUAL table.
This seems like a bad idea to me. I've never had
Cherie,
My first response is 'WHY?'. Do they mean that they want to create 2
new sequences and use the DUAL table to retrieve the values? It will cause
performance problems and there are better solutions. I have some information
on the performance implications of DUAL at
Communication gap and ignorance. The developers proably want to create new
sequences. And they are used to writing queries as Select
sequencename.nextval from dual; So they call it sequences on the dual
table.
Think about how you will roll the trend data up over time. That is
usually the real killer task. That is why you got people talking
mrtg, because it is the poor man's solution to that problem. At least
it is one wheel that has already been invented at the right price.
The snapshots you are
Sounds like your developer hangs out with some of our developers! ;)
I am sorry to say but, I guess the syntax ...from dual could be confusing
to the developer.
Your understanding is just fine. Don't do anything with dual..
May be briefly explaining to the developer how sequence number
Title: RE: DB/APPlication?
Seema,
That's part of the tnsnames.ora which the client needs to connect to the database.
Check out the alert.log file and look for any trace files for the reason the DB crashed.
-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Monday,
Title: RE: Creating sequences on the DUAL table?
Sequences are DB objects independent of any tables including dual (not
possible to create a sequence on a table. Sequences are sometimes used
to populate the PK of a table, but the actual sequence and the table are
not structurally related.
Oh fdge. (Only I didn't say fudge). 10-watt bulb:on After
transcribing all my install problems here, I just realized that I'm supposed
to be using DBD::JDBC instead of DBD::Oracle, aren't I? Hey, I was working
on this at 1:00 AM this morning...
Never mind... blush
Thanks, Jared! :)
What are sequence on the table? All I know about sequences
is that they are entities for fas generation of unique numbers
without encountering locks. They are standalone entries without
much connection to any other object.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Cherie,
You don't create sequences on a table, they are objects in and of
themselves.
So you can create the sequences for the developers but I'm
wondering where they got the notion that sequences were created on a
table. And why they want to use DUAL.
Rachel
--- [EMAIL PROTECTED] wrote:
No, I use a hex editor and directly write the bits to disk.
Isn't that the way everyone here does it?
Jared
Straub, Dan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/30/2002 10:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Dan,
Haven't heard the why yet but I think it may be just a poorly worded
request. I suspect he wants the sequences created on another table and
just wants to be able to select from dual. Maybe he never realized that
the sequences were actually created on another table.Maybe he actually
Hex editor? geez you youngsters have it soft, in MY day we ran magnets
over the disks to encode the ones and zeros :)
--- [EMAIL PROTECTED] wrote:
No, I use a hex editor and directly write the bits to disk.
Isn't that the way everyone here does it?
Jared
Straub, Dan [EMAIL
Title: RE: Ids and passwords for application users
Peter,
not clear on if the database is going to be used by developers doing
development work or will an application use it and you'll have up to 300
application users?
If it's an application, how about making one account that owns all of
Hi list ,
In one of my queries if I use in where
clause it is causing full table scan . If i use "IN " ( ) it uses
index . Actually if it is" " the it is doing hash join and if"IN"
then nested loop .
when i make opt_indx_cost_adj to 5 it starts using
index again with condition .
Is
Title: dbsnmpj access violation
Hi all,
I've just finished installed 9.2 on W2K. Whenever I submit a job through the OEM console the dbsnmpj.exe process gets an access violation and the job fails to run. When I enable tracing on dbsnmpj, it works fine. Disable tracing and it dies again.
Kevin,
Thanks for the suggestion on select statements. I will pass them on. I
think it's just a misunderstanding on his part as to where the sequences
are actually created. Apparently he only uses them in a select from dual
so he thinks they reside there.
Cherie
coding? ha! I used to flip switches to load my programs directly into core
memory! and then I had to read the results from the light console! up-hill
both-ways in a snow-storm!
-Original Message-
Sent: Tuesday, July 30, 2002 3:20 PM
To: Multiple recipients of list ORACLE-L
Hex
Title: RE: ODBC connection privs in Oracle
Privileges would be that of the account specified in the ODBC connection setup, which
are Oracle specific for the Oracle user. What do you mean by The privs do not appear to match Oracle-based security.?
-Original Message-
From: Boivin,
Every single message I get on this post gets blocked:
Can't tell you but how I am wondering what is being said!
-Original Message-
Sent: Tuesday, July 30, 2002 3:07 PM
To: Multiple recipients of list ORACLE-L
The original message content contained a virus or was blocked due to
Cherie,
If you push F1 key from SqlPlus there will be a complete explanation called
'all about sequences and how to create them on dual table'.
-Original Message-
Sent: Tuesday, July 30, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L
Dan,
Haven't heard the why yet but I think
I would think they probably saw something like
select sequence_name.nextval from dual;
Maybe they thought the sequence and dual were connected in some manner.
-Original Message-
Sent: Tuesday, July 30, 2002 2:15 PM
To: Multiple recipients of list ORACLE-L
Cherie,
You don't create
Looks like most of the replies point to VFP. I will present this to my
manager. Thanks to all who replied!
Dennis Meng
Database Administrator
Focal Communications Corp.
GROAN Here we go again. So who's gonna be the first one with the abacus
joke this time?
--Walt (who makes Rachel look like a spring chicken) Weaver
Bozeman, Montana
-Original Message-
Sent: Tuesday, July 30, 2002 1:20 PM
To: Multiple recipients of list ORACLE-L
Hex editor? geez you
1 - 100 of 162 matches
Mail list logo