dear list,
The setup:
app server 9ias
1.0.2.2.2a
db server 9i R2.
The application
Our app connects to the DB using
JDBC thin, a simple app showing fields and inserting data into
underlying tables.
The problem
All was working fine, then the
management asked us to use RSA/ACE security
Hi!
Trailing columns with NULL values do not occupy any space, not even a
length
byte.
Yep, I missed this one. Also, when few trailing null columns aren't stored
in a row, this particular rows column count is smaller as well, so the
column count in physical table storage can vary...
Hallo,
Maybe this sounds simple for all of you, but I have a table with the field PRICE and
that is with datatype varchar2 I want the data in that field to be inserted in another
table with field PRICE, but that field has the datatype NUMBER. How can I
deasiest do this sql statement?
I really
Hej Roland (Sverige?),
I doubt that. If all the data is number in the varchar2 column, well, you
don't need it to be varchar2.
The easiest solution seems to be:
INSERT INTO newtable SELECT TO_NUMBER(col) FROM oldtable;
Premise: all your data in that column IS number. If you're not sure,
do
Hallo,
Maybe this sounds simple for all of you, but I have a table with the field PRICE and
that is with datatype varchar2 I want the data in that field to be inserted in another
table with field PRICE, but that field has the datatype NUMBER. How can I
deasiest do this sql statement?
I really
What's the data like in the varchar field? Is it in number format? A quick
sample would be good.
-Original Message-
[EMAIL PROTECTED]
Sent: 03 November 2003 11:14
To: Multiple recipients of list ORACLE-L
Hallo,
Maybe this sounds simple for all of you, but I have a table with the
In the varchar2(30) field PRICE , table1 it looks like this
PRICE
12,50
37,50
The datype in table 2 is for that field NUMBER(7,2)
Hope this would be of anyhelp
Rolabd
Trigger using TO_NUMBER function would be the first thing that comes to mind.
I have designs like that, which are used for parsing so calld Bloomberg
files. Those files contain strings like N.A., -,|| ('|' is the field
delimiter) and all of those strings mean NULL. Also, stock split ratio can
Hallo,
Maybe this sounds simple for all of you, but I have a table with the field
PRICE and that is with datatype varchar2 I want the data in that field to be
inserted in another table with field PRICE, but that field has the datatype
NUMBER. How can I
easiest do this sql statement?
In the
Niall,
LINDESK isn't the flaw, it is the method that the server handled the
request from a non-windows browser. They have fixed the problem and the
application now works from any OS browser.
I ment the info to be a potential security alert.
Ron
[EMAIL PROTECTED] 10/31/03 03:49PM
I'm not
Yes but how should I write the sql statement when to make the incoming varchar2 field
into a number?
Roland
Mladen Gogala
This should be helpful,
SQL create table tt1 (c1 varchar2 (30));
Table created.
SQL insert into tt1 values ('123,50');
1 row created.
SQL insert into tt1 values ('44567,9');
1 row created.
SQL insert into tt1 values ('1,23456');
1 row created.
SQL commit ;
SQL select * from tt1 ;
C1
Rahul
My understanding is that the JDBC thin client does not use Net8 across
the network, but just connects directly to the listener. For example, on
client systems that use thin client, I have not had to configure a
tnsnames.ora. The way I understand secureID works, something on the client
Oracle's response is that the Designer documentation is all in the online
help.
That this decision was made for Designer 2.0, in 1998.
Patrice.
-Original Message-
Sent: Tuesday, October 28, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
I have had the same problem. I have
Can you re-post this question several more times? We didn't get it yet.
Thanks in advance for your understanding.
On 11/03/2003 07:29:40 AM, [EMAIL PROTECTED] wrote:
Hallo,
Maybe this sounds simple for all of you, but I have a table with the field
PRICE and that is with datatype varchar2 I
Mladen,
Unfortunately, the density of your proposed option has warped the space continuum
around us and made this option unusable...
That and the fact I would have to take two years of University Mathematics to fully
comprehend and appreciate the theory, makes this less than optimal in terms
INSERT INTO new_table(price)
SELECT REPLACE(price, ',' ,'.')
FROM old_table;
Rick
Mladen Gogala
Hi
Not sure what the original question was BUT the script offered splits
exports so you may be interested in a tool Kurt van Meerbeeck and
Kugendran Naidoo wrote called Ora*PePi availbale on sourceforge - the
description from there reads:
quote
Ora*PePi is a superset of the Oracle export/import
in European notation, the , is used where Americans use a . and vice
versa. makes for interesting reading of white papers but the replace
statement below will distort the data being entered
--- [EMAIL PROTECTED] wrote:
INSERT INTO new_table(price)
SELECT REPLACE(price, ',' ,'.')
FROM
Shibu,
I'd go ahead and check your system according to the bug (it may or may not be present,
my memory is a little foggy on the issue). If it is only 1 log, I would look to some
other cause (disk), but if you find the corruption in several logs, it points to
something inside the db (not
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jeffrey Beckstrom
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
I picked up Mark Gurry's SQL pocket reference on Friday and it states that you can
radically improve performance of 'where exists' statements by using semi-joins since
it only returns the sub-query ones.
Now logically you have to return the sub-query repeatedly, this would only come into
play
I have always been comfortable with the idea that Sequences continue to
guarantee
uniqueness even in OPS / RAC environments.
However, a recent Builder.Com article by Scott Stephens on the SYS_GUID
function has these lines :
Sequence generator numbers are guaranteed to be unique only for a
Hemant,
I would guess that this is true if you are caching values for the sequence.
Each database instance might cache the same set of values.
Turn sequence caching off, and I would think that the problem goes away.
Havn't tried this in awhile, but it makes sense.
Tom Mercadante
Oracle
me don't think so.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
If the data is really a number ( ie. no alpha characters )
you don't need to do anything, Oracle does an implicit conversion.
insert into my_table_numeric( real_number_column )
select my_stupid_varchar2_col
from I_hope_these_are_all_numeric_table
/
Jared
On Mon, 2003-11-03 at 04:44, [EMAIL
In the Oracle9i Real Application Clusters Administration manual, there is a chapter
about sequence numbers generator. Before believing to the snake oil sellers, read
the fine manual. Sequence numbers are guaranteed to be unique PER DATABASE. What
they're
not guaranteed is to come in ordered
Sequences are mastered by the single SYS.SEQ$ table in each
database. Cached or uncached, RAC or non-RAC, OPS or
non-OPS, sequence numbers generated by this mechanism are
unique across a database, not by instance. Each instance
updates SEQ$ as individual numbers (noncached) or ranges of
numbers
thanks for the info Muqthar Ahmed,
I will follow the steps and let you know what happens,
thanks again!
Saludos,
Verónica Levin Enríquez
GTI
Compañía Cervecera de Nicaragua
-Mensaje original-
De: Muqthar Ahmed [mailto:[EMAIL PROTECTED]
Enviado el: Friday, October 31, 2003 11:19 AM
Yes, I've been aware of the difference between ORDERED and CACHED.
However, the Builder.Com article quite explicity asserts
Sequence generator numbers are guaranteed to be unique only for a single
instance, which is unsuitable for use as a primary key in parallel or
remote environments, where a
Thanks KG.
There were underlying OS I/O issues. The SA is looking to fix the same.
Regards
Raj
__
Rajesh L. Rao
DCI - Triad, Oracle DBA
IBM Global Services, JPMC Account
Phone: 516 5746065
E-mail: [EMAIL PROTECTED]
Hello Hemant,
Monday, November 3, 2003, 11:29:26 AM, you wrote:
HKC However, the Builder.Com article quite explicity asserts
HKC Sequence generator numbers are guaranteed to be unique only for a single
HKC instance, which is unsuitable for use as a primary key in parallel or
HKC remote
On 11/03/2003 12:04:26 PM, Jonathan Gennick wrote:
Can you point us to the article? My guess is that the author
is not familiar with Oracle,
That shouldn't be considered enough of a reason not to write articles
about oracle, should it?
Mladen Gogala
Oracle DBA
Note:
This message is
Hi,
I have RAC and I always use ORDER when I create SEQUENCE. The following information
is from Oracle Manual:
ORDER is necessary only to guarantee ordered generation if you are using Oracle with
Real Application Clusters. If you are using exclusive mode, sequence numbers are
always
This is not appropriate for this list.
Please refrain in the future.
Jared
hrishy [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/01/2003 05:19 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE:
Ok, what is LINDESK?
I googled for it, but found nothing informative.
Jared
Ron Rogers [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/03/2003 04:44 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Win
if thats the case, how is a semi_nl useful? its doing a nested loop also.
There is alot of academic talk on semi-joins on the web, but I cant find an algorithm
anywhere. The basics of it appear to be generic.
From: Tanel Poder [EMAIL PROTECTED]
Date: 2003/11/03 Mon PM 12:49:25 EST
To:
Hi!
I don't know the exact algorithm either, but check
the execution plans:
SQL set autot trace expSQL select name
from obj$ 2 where exists (select 1 from tab$ where obj$.obj# =
tab$.obj#);
Execution
Plan--
0 SELECT STATEMENT
hi tanel and mladen
not every time a process is started does it swap but sometimes swapping does happen.(this is from the top o/p which shows a increase in the memory used in swap.).how do we check whether a single process swaps or not?
and the dbw process is using more % of memory than a couple
The problem is that the ORDER clause comes at the expense of
CACHE. You can use SQL tracing to verify that each use of
the sequence causes an update of SYS.SEQ$ when ORDER is set,
effectively rendering the CACHE setting a no-op. So,
especially in an OPS/RAC environment, the use of ORDERED
List,
Doing some reading on Normalization today. We actually have the opportunity
to create a database and app, and it's been so long since I've done this on a real
project, a refresher was in order.
I have the annoying habit of knowing what to do with normalization, based on past
education and
Hi,
My fatcity account from gawab.com does not work. Is it working for ne 1. Thank you
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
Hi,
Can someone post a list of other oracle dba forums like this one. Again. I think someone hadposted it sometime back.Thank You.
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
Jared,
LINDESK is a package for linux that allows terminals-services for
windows to be used from the linux OS.
www.terminal-services.net The product info is linRDP and creates to
application lindesk.
Ron
[EMAIL PROTECTED] 11/03/2003 12:54:26 PM
Ok, what is LINDESK?
I googled for it, but found
Title: Message
Hi Jared,
Just
so I'm clear which one to avoid, are you referring to the one that links to the
excerpt from this book?
Sams Teach Yourself SQL
in 21 Days, Second Edition
The reason I'm asking is I entered your URL below but
received a "Page Not Found" error.
When I
ive seen tom kyte say the same thing. normalize unless its bad for design and/or hurts
performance.
which is similiar to normalize until its inconvenient.
you could have some real fun and try to explan the boyce-codd normal form from an
academic text book :)
From: [EMAIL PROTECTED]
Date:
The newsgroups comp.databases.oracle.XXX, where XXX is server, misc, tools or
marketplace. DBA issues are mostly discussed at ...server. If you don't have
direct access to Usenet, go to groups.google.com or www.mailgate.org. Personal
opinion: Jonathan Lewis is still there. Other experts only visit
change the url to www.tinyurl.com/th7i
--- Melanie Caffrey [EMAIL PROTECTED] wrote:
Hi Jared,
Just so I'm clear which one to avoid, are you referring to the one
that
links to the excerpt from this book?
Sams Teach Yourself SQL in 21 Days, Second Edition
The reason I'm asking
A Joshi wrote:
Hi,
Can someone post a list of other oracle dba forums like this one.
Again. I think someone had posted it sometime back. Thank You.
Google is your friend. Just search for Oracle dba mailing lists and a whole slew
of results are returned.
HTH,
-Brian
--
Please see the
Jared - The book that has helped me the most is The Data Modeling Handbook
by Reingruber and Gregory. Their approach is to develop a best practice for
each modeling situation.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, November 03, 2003
Jared, I'm sure that the three of you can easily do it. Good luck.
On 11/03/2003 01:34:26 PM, [EMAIL PROTECTED] wrote:
List,
Doing some reading on Normalization today. We actually have the
opportunity
to create a database and app, and it's been so long since I've done this
on a real
Found a site with some 10g new features.
http://www.adp-gmbh.ch/ora/misc/10g.html
I'm sure some will like the new 'alter tablespace rename'
http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux
Jared
Thanks, Rachel.
Obvious answers like the below elude my overworked and sleep-deprived
brain right now :)
Long work weekend and all that ...
Guess I'll leave poor Sams alone, then.
-Original Message-
Rachel Carmichael
Sent: Monday, November 03, 2003 2:15 PM
To: Multiple recipients
Title: Message
Thank
you Jared.
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]Sent: Monday, November 03, 2003 11:50
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Outsourcing's dirty secretThis is not
Hi:
Are there any resources out there (official Oracle or otherwise) that pertain to installing both Enterprise and Standard on the same box.
Regards,
Gary Norwell
Systems Analyst
Hybrid Turkeys
mladen
i have gtop...and i am trying to get thru the preferences which u have mentioned.
1. can you please help me to find the kernel mode for the processes.
2. on this linux box i see that demon kswapd and bdflush in the process list.should they always be running or do they get intiated only
There is no forum like this one. There is no place like 127.0.0.1.
On 11/03/2003 01:34:34 PM, A Joshi wrote:
Hi,
Can someone post a list of other oracle dba forums like this one. Again. I think
someone had posted it sometime back. Thank You.
-
Do you
All,
Just wanted to point out that 'missing' invoice numbers caused by a variety
of causes (even if they were not cached), can cause problems for
Accounting/Finance Depts in certain countries. Basically, the Govt looks on
this as being used for 'tax avoidance', unless proved otherwise. You *can*
Funny you should ask for this definition.
Boyce-Codd Normal Form (BCNF)
* Formal definition:
* Every determinant must be a candidate key
* Stronger form of 3NF
* 3NF: Every determinant of a non-key column must be a candidate key
* Applies to tables with more than one candidate key
* Candidate
Title: Message
may
best brains survive where ever it is.
-Original Message-From: Anjan Thakuria
[mailto:[EMAIL PROTECTED]Sent: Monday, November 03, 2003 2:34
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Outsourcing's dirty secret
Thank you Jared.
Regarding the posting of 'on topic only' messages:
That is highly subjective. What I call on topic you may
not agree with.
Then there is the issue of time. I already spend way too
much time on this list. Moderating to the degree that
some may like is simply out of the question.
Jared
What is the actual concern with it?
Installing both EE and SE on the same *nix or Win32 box is pretty straight forward,
provided you aren't trying to do so with Version 7 on Win32.
You don't do anything special, just install them, create your databases, edit
tnsnames, etc.
If your question
Preferences-Process Fields-STime, UTime.
On 11/03/2003 02:44:34 PM, Sai Selvaganesan wrote:
mladen
i have gtop...and i am trying to get thru the preferences which u have mentioned.
1. can you please help me to find the kernel mode for the processes.
2. on this linux box i see that demon
scaryvoice Do not attempt to leave us, we are the only forum you
need. We now have your email address, you'll be forced to seek us out
in the future for all of your oracle needs. /scaryvoice
Darn halloween is over, never mind.
search google as state before.
joe
A Joshi wrote:
Hi,
Can
the person who made this post has a habit of asking hte exact same question on this
forum and lazydba.
i hope he dosent decide to expand that to 5-6 forums.
From: Yong Huang [EMAIL PROTECTED]
Date: 2003/11/03 Mon PM 02:04:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Hi List,
Does oracle provide any utility to convert sybase stored
procedure into oracle stored procedure. In OTN I found some
document which docs about conv72 which was distributed with
oracle 7.2v. I dodn't see nything similar in oracle 8i or 9i.
Does anyone have any idea or experience on
Hello Fellow Oraclers
Has any of you come across installing Oracle 7.3.4.0 on Windows 2000.
Can any of you share your experiences with me.
I am aware that 7.3.4.0 is not certified by Oracle to run on Win 2000
however my requirements dictate I carry out the stated task. I tried to
install and it
That's a nice article. The author could have enhanced it by adding or changing
some wording.
The buffer cache can be flushed with alter system flush buffer_cache. - ...
instead of using the undocumented alter session set events = 'immediate trace
name flush_cache' in 9i
SQL: Regular Expressions
Oh, I have *tons* of data modeling books/articles.
Just needed a quick refresher for the purpose of offering explanations.
Jared
DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/03/2003 11:14 AM
Please respond to ORACLE-L
To:Multiple recipients of list
I believe Oracle Migration Workbench will convert your Sybase
(Transact-SQL) procedures to Oracle (PL/SQL). The tool is normally used
to migrate an entire database, but I believe it gives you the
opportunity to be very selective on which objects to migrate. The tool
may require more effort than
Look for Migration Workbench on OTN.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Saminathan
Sent: Monday, November 03, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L
Hi List,
Does oracle provide any utility to convert sybase stored
procedure into oracle stored
What we have here is a confusion with terminology.
Process cannot be swapping. When there is a serious shortage of memory, the swap
demon
(yes, your Unix box is haunted) known by the horrible name of [kswapd] writes the
whole
address space space belonging to the process onto swap. At that
Gary - I haven't done this exact task, but I would think it would be similar
to having different Oracle versions on the same server. Just make sure you
use a separate ORACLE_HOME for each and watch any other conflicts like the
same path being used for each.
Dennis Williams
DBA
Lifetouch, Inc.
The service for OracleTNSListener will show up once the Listener is
started. Try starting it from the command line using lsnrctl. This has
worked for me.
RWB
Reginald W. Bailey
IBM
Perhaps Oracle Migration Workbench (OMWB) is something
you could look at.
As I understand, it converts Sybase stored procs to
oracle functions by default (since Sybase stored procs can
return a result set, but Oracle Stored procs cannot).
Todd
Hi List,
Does oracle provide any utility
Jared - Sounds fine. Do you feel you received the information you needed?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, November 03, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L
Oh, I have *tons* of data modeling books/articles.
I realize ORACLE-L could not be the best place to ask this question but
(googling/metalink-ing did not help overly)...
ORA-60 happens in our own application in the worst of possible places
- at the customer's site. It happens intermittently. All I can do is look
at the alert log for
COALESCE would be a better option than REBUILD for Indexes on
monotonically increasing sequences where older values are purged periodically.
Unless you happen to be doing index_ffs on that particular index, in which
case a rebuild *may* be in order. Rebuilding the index may cause insert
More than enough. :)
DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/03/2003 12:49 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Database Normalization
Jared - Sounds fine. Do you feel
Also check out
http://www.cs.auc.dk/research/DP/tdb/TimeCenter/TimeCenterPublications/TR-28
.pdf
by Richard Snodgrass.
Henry
-Original Message-
Mladen Gogala
Sent: Friday, October 31, 2003 6:09 PM
To: Multiple recipients of list ORACLE-L
Ron, it's not as stupid as you might think. Of
Thanks Ron.
I currently use rdesktop for that: www.rdesktop.org
It doesn't appear to be worthwhile ( at least to me) to
compare them, as rdesktop works very well, and is GPL.
Jared
Ron Rogers [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/03/2003 10:54 AM
Please respond to ORACLE-L
This event is one of those 'you would never see' in normal database
operations. As I have mentioned
in my earlier post, existance of this event translates in to some serious
I/O issues or broken disk in RAID05
or something similar to that..
- Original Message -
To: Multiple recipients
We did that this year except it was 8.0.6 SE and 8.1.7 EE. No big issue.
Other than having 2 listeners on different ports the most annoying task was
that the method of setting the Oracle Home and associated environment
variables for the usage by the shell scripts and the database start
Arif,
I have not tried this particular arragement (9.2 listener, 7.3.4 db) but,
The current Oracle 9i Release 2 (9.2.0.4) listener would be the recommended listener to use. If you do not want to install that version, please use the 8.1.7 listener with the 8.1.7.4.1 and 8.1.7.4.12 patchsets
Hi,
I have a quick question that doesn't seem to be answered in the
documentation. We have a database that has a database character set of
WE8ISO8859P1 and a national character set of UTF-16. Currently we are not
using any NCHAR, NVARCHAR2 or NCLOB columns, but would like to soon.
However,
Snodgrass is also the author of an excellent book on the subject, available
at a bookstore near your browser.
Henry Poras [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/03/2003 01:49 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Hi listers,
Configuration :
Hp-ux 11i
Oracle 9iR2 with RAC (2 nodes)
OSD clusterware : MC/Service Guard 11.15
Oracle software is installed on each node and
the database is on shared raw devices.
Any experience/gotchas implementing OFA on RAC without cluster file systems?
In
Alan,
Unfortunately UTF-8 and UTF-16 is in fact different in their binary representations
and hence you will have to perform a full fledged conversion to map the UTF-16
characters to their UTF-8 binary representation. You can use the dump() SQL function
to see this for yourself if you have
Has anyone run into any problems with this combination?
The MetaLink note # 45997.1 says it should work fine, but it would
be nice to hear from someone that has implemented 9iR2 on NT.
Why NT? I need to put an app on a server that already has licensing
for backup software etc. Beats spending
Well with RH latest ordeal of jumping out of simple ISOs and basically
no more free software, what is oracle's stand on running on RH?, the
paid version only from now on and those linux users out there, what are
WE going to do?
Looking to see if i need to spend money before end of year for
Yes! RMOUG Training Days is going to be an incredible event this year! A
2-day conference in Colorado during ski season with a lineup of speakers
that rivals the major international conferences, including keynotes by Bill
Inmon and Sue Cook! We're going to have a blast; I'm looking forward to
Jared:
'alter tablespace rename' is not the REAL 10g
feature. It is available
from 9.2 onwards... :) Hope you know what I
mean,,
KG
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, November 04, 2003 12:54
AM
Thank you, let me explore it.
-Original Message-
Todd Boss
Sent: Monday, November 03, 2003 3:50 PM
To: Multiple recipients of list ORACLE-L
Perhaps Oracle Migration Workbench (OMWB) is something
you could look at.
As I understand, it converts Sybase stored procs to
oracle functions
Bill Inmon? Cool. Dan won't tell me more than it's going to be
incredible
lots of my friends there, even if I do have to fly in at midnight the
night before and fly out at midnight the night after :)
--- Tim Gorman [EMAIL PROTECTED] wrote:
Yes! RMOUG Training Days is going to be an incredible
Well, if RedHat starts exhibitting tendencies of becoming another Microsoft,
there are Mandrake, Debian , SuSE and (don't shoot, I'm just kidding) SCO.
(duck, and quickly)
On 2003.11.03 20:54, Joe Testa wrote:
Well with RH latest ordeal of jumping out of simple ISOs and basically no
more free
Actually, I don't understand what you mean. Here is 9.2:
SQL create tablespace test datafile '/data/oradata/data/test01.dbf'
2 size 10M extent management local autoallocate
3 segment space management auto;
Tablespace created.
SQL alter tablespace test rename to test01;
alter tablespace test
Gopal was joking about the fact that Jared only said 'alter tablespace rename'
instead of ALTER TABLESPACE RENAME DATAFILE.
In fact, 9.2 SQL Reference has this
Moving and Renaming Tablespaces: Example
This example moves and renames a datafile associated with the tbs_01 tablespace
from
This is news to me. RH will no longer let you download Linux for free?
hmmm
Sure enough, look at http://www.redhat.com/apps/commerce/rhel/ws/
The cheapest version is $179.00 US. Looks like the next version
for me will be Gentoo.
Jared
On Mon, 2003-11-03 at 17:54, Joe Testa wrote:
Well
Not sure I get it either. :)
The command listed on the 10g site that I referred to is this:
alter tablespace ts_user rename to ts_user_01;
Renaming a tablespace is apparently possible with 10g.
Must be a joke here somewhere I'm missing.
Jared
On Mon, 2003-11-03 at 20:09, Yong Huang
How can *you* not get it? Gopal says in Oracle 9.2, 'alter tablespace rename'
is possible. Of course. The full syntax is alter tablespace mytablespace rename
datafile '/path/file.dbf' to '/path/newfile.dbf'. You see the three words
'alter', 'tablespace' and 'rename' in there?
You'll get it in the
1 - 100 of 103 matches
Mail list logo