Dear Listers ,
I want to try using RMAN in just 1 machine with 2 databases ( client and target ) .
I have followed every single step in manual , but there's always error ...
Do we must run RMAN in 2 machines ?
Thank a lot in advance : )
=bambang=
Bambang Setiawan
--
Please see the
Hi there,
I have some problems to export any table, so it seems, of my Oracle 7.3.4
database. I run into the following error:
EXP-3: no storage definition found for segment (name, num)
Cause: Export could not find the storage definitions for a cluster,
index, or table.
Dear DBA Gurus,
I have around 30 tables for which the columns, datatypes, size of
each datatype, referential integrity constraints is decided. I need to draw
E-R diagram linking each table with one or many tables. I am looking for a
tool which will draw the diagram for me if I
hi Bachman,
I wonder how you could have an index that is out of your schema,you mean you
built it with another user?
Anyway,the workaround you wrote would do it.
did you try the command prompt for export instead of using the Gui at the
server?
I got used to command prompts than GUI tools on the
Hi,
in my opinion, Jared is only partly right. PL/SQL is a handy procedural
language extension to plain SQL. Since SQL derives from the family of
declarative languages (by the way, what happened to all the research in
the late 80s/ early 90s about hooking up PROLOG engines to RDBMSs ?
AFAIK, the
Hi,
You can try a software from embarcadero ,
perhaps www.embarcadero.com , ( if I'm not wrong spell it ) ...
or
go to www.platinum.com to download Erwin ...
hth,
bambang
Bambang Setiawan
"Ranganath K" [EMAIL PROTECTED] 04/17/01 03:50PM
Dear DBA Gurus,
I have around 30
Hi ...
-Ursprngliche Nachricht-
Von: MOHAMMAD AMER [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 17. April 2001 10:51
An: Multiple recipients of list ORACLE-L
Betreff: Re: [EXP-3: no storage definition found for segment]
hi Bachman,
I wonder how you could have an index
hi,
ya there are tools which can do this work for you. one such tool i know is
Platinum ERwin, but i don't know whether it's free or not. but what i feel
is u can get some trial version of it.
try getting some more info about how to get it.
but one thing i tell u, it's really a good tool. i've
Me too, Me too!!!
ROR mm
Ron Rogers
DBA OCP
Georgia Lottery Corp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
Geez, enough of the political debates! Let's get back to the business at hand.
Here's an announcement from our favorite vendor:
Don't Let Microsoft's Claim of Superior Database Security Fool You
In a clever attempt to turnaround its weak security image, Microsoft issued a press
release
If your indexes are local then no problem . If the
indexes are global you 'll have to rebuild them .
--- [EMAIL PROTECTED] a crit:
I've looked through the on-line documentation on
dropping partitions
but I have not seen the following question
specifically addressed:
How does dropping
This article from NYTimes.com
has been sent to you by [EMAIL PROTECTED]
a reasonable response to an unreasonable email
/ advertisement ---\
Let NYTimes.com Come to You
Sign up for one of our weekly e-mails
and the news will come directly to you.
Eric - I couldn't agree with you more! Well said!
[EMAIL PROTECTED] 04/16/01 10:10PM
Celebrate the entreprenurial spirit:
http://www.popcornfork.com/
excerpt:
---
"CAUTION Ordering and using the
POPCORN FORK will
automatically cancel your
membership in the FLAT WORLD
SOCIETY!
Title: RE: Meeting at IOUG
I'm going to be there
(I better, I'm supposed to be giving
four presentations)
Also, for anyone in the central Ohio area,
on thursday the Ohio Oracle Users group will be meeting
at which Gaja and I will both be presenting.
See www.ooug.org for more details
No, I backup databases on 3 machines using rman. Our recovery catalog
database is on our production machine and I backup my production databases
on that machine.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 3:20 AM
I do not know of any good modeling tool for free, they
all charge $$$.
I found it a bit strange that you have all the
physical layout done then want to do an entity-
relationship diagram after...
--- Ranganath K [EMAIL PROTECTED] a crit:
Dear DBA Gurus,
I have around 30 tables
Good Morning!
Just wanted to thank everybody for their responses and excellent feedback.
Renaming the file worked like a charm. This allowed me to create the
controlfile of the new database and bring it up w/o any problems.
Now I know :-)
Steve
-Original Message-
From:
Scenario:
AIX, 8.1.6.3.
Cognos cube building going on.
select count(*) from ft_sales, shows up 0 rows, its using a bitmap index out
of the explain plan.
I force full table scan or force to use other bitmap index, or PK(normal
index) and it comes back with correct count(20+ million).
Anyone
Maybe you should mention how much better China is than the US to all the
Chinese people willing to risk their lives crossing the Pacific in cargo
holds in search of a better life here.
-Original Message-
Sent: Monday, April 16, 2001 4:21 PM
To: Multiple recipients of list ORACLE-L
I have installed Oracle Developer/2000 on my machine. When I try and open
up Forms I get an error message:
Message file C:\ORACLE_HOME\DBS\FMCUS.MSB not found.
I looked for the file in that directory and it is definitely not there.
Any ideas?
Thanks,
Eric
--
Please see the official
You could use the alter index rebuild option. This
keeps the old index available for queries until the
new index has been created. You just need to make sure
you have double the space of the object you are
rebuilding when using this technique.
James
--- Seema Singh [EMAIL PROTECTED] wrote:
Hi
I will be there also.
Sandra Arnold
DBA
Strategic Staffing Solutions
-Original Message-
Sent: Tuesday, April 17, 2001 7:55 AM
To: Multiple recipients of list ORACLE-L
Me too, Me too!!!
ROR mm
Ron Rogers
DBA OCP
Georgia Lottery Corp.
--
Please see the official ORACLE-L FAQ:
Here is the MV log and the MV, it's generating an
ORA-12032 when trying a refresh fast.
create MATERIALIZED VIEW log on sp_ect_etat_contrat
with primary key
(ECt_ID_PRODUIT,
ECt_CD_SERIE ,
ECt_CD_SOURCE ,
ECt_CD_AGENCE ,
All,
Is there a method
forallowing a non DBA user to kill their own (and only their own) session.
I have had a trawl through Metalink and have seen various methods (using
procedures) of doing it but all of these appear to rely on granting the alter
system role to the user.
Oracle
Top-notch company in Denver, Colorado needs an Oracle Deployment Engineer
(DBA) who has
Unix Systems Administration experience.
This organization is not particularily a "button-down" company.
The selected candidate will plan and coordinate installations or upgrades
of software, provide
Anybody know where oracle has moved (hidden) their ftp address now?
What doesn't work:
ftp://external-ftp.us.oracle.com
ftp://209.246.5.40
ftp://205.227.44.220
ftp://oracle-ftp.oracle.com
In case it helps, the error I get says "An error occurred reading the
contents of the folder. Make sure
Tim,
I'll agree, as I remember it the C2 security spec was a farse compared to
todays reality. OH, BTW, the first NSA approved database for Confidential and
higher data was "Trusted Oracle7". All of the others were only certified for
"For Official Use" and lower data. And back in 92
Stephane,
Thanks for your reply.
Cherie
paquette stephane
Michael Sun wrote:
Peace on earth and de-fragmented Oracle database everywhere.
"Peace on earth" was the password from the movie called "Dr. Strangelove",
in my opinion one of the best movies ever made. De-fragmented databases
are not an issue any more now that we have locally mismanaged
Thanks for all!!
I applied the patch 8.1.6.3.0 and everything was right!
Again, thank you!
--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--
Gilberto Gampert Universidade de Passo Fundo
Administrador de Banco de Dados Passo Fundo - RS - Brazil
hi,
i am looking for a sql statement which can tell me the
current sql running in oracle.
TIA
Srinivas
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L
Since we're talking 32 VS 64 bit, anybody know when
Oracle 817 64 bits we'll be available on Solaris ?
Oracle.store only shows Oracle 816 64 bit for Solaris.
If you do not need to adress a huge SGA, what are the
benefits are running Oracle 64bit instead of Oracle 32
bit ?
--- [EMAIL
ftp://oracle-ftp.oracle.com
[EMAIL PROTECTED] 04/17/01 11:00AM
Anybody know where oracle has moved (hidden) their ftp address now?
What doesn't work:
ftp://external-ftp.us.oracle.com
ftp://209.246.5.40
ftp://205.227.44.220
ftp://oracle-ftp.oracle.com
In case it helps, the error I get
Good morning everyone,
HELP! HELP!!!
It's very early in the morning and I'm still struggling with the
Oracle Hot Standby - 8.0.5 and 8I. ARGH!
Ok, I got the failover going. I can activate the standby database and
use it as a normal database. But when I try to turn it into a standby
database
Regrettably I don't recognize the e-mail address, but then I don't recognize
too many of them. At any rate, and I do want to keep this short, That's one
very good article with words of wisdom for BOTH sides in this war of words. Am
I upset with China, no not really. I think the leadership
Lee,
In
short, you can't achieve this within Oracle domain short of granting ALTER
SYSTEM to user in question or going via PL/SQL procedure owned by other, more
protectedschema.
However, a tool like TOAD will provide similar capability for you - a
user is capable to "cancel" long running
ftp://external-ftp.us.oracle.com
ftp://205.227.44.220
ftp://oracle-ftp.oracle.com
These worked for me.
Brian L. Anderson
Flunky/SA/DBA/DERT
Darton College
[EMAIL PROTECTED]
-Original Message-
I'll be there and would like to meet as many of you as possible. If anyone who knows
the ropes can suggest a time/place, that would be great. As this is my first IOUG
event, I don't have any ideas on where/when, so it's up to all you "veterans".
Keep this thread going.
Stephen Andert
I'll be there too! It will be my first visit to IOUG and I'm looking
forward to meeting the many folks who have contributed to my knowledge [and
amusement] through this List. Even though I don't often post questions,
your advise to others have been very useful. Keep up the good work.
Bill
I will be upgrading our database and application server from 8.0.5.2.1 and
11.0.2 to Oracle 8.1.6 and Applications 11.5.3.
I understand from reading the upgrade manuals as well as confirming from Oracle
support that the database must have a db_block_size of 8k or larger. We are
currently
Michael,
I disagree strongly w/ your comments about a peacefully defragemented Oracle
database. See the article called "How to Stop Defragmenting and Start
Living".
Mike
From: "Michael Sun" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
Hello all,
I know, I know - An Oracle list. However some of us work with many
databases (our shop has Oracle, SQL Server, Adabas, and Sybase), so maybe
someone on this list can help. The subject line should give enough info to
delete the message if you hate the 'other' databases.
I was
in gaining knowledge about oracle I've been introduced to some concepts,
components, and concerns and I'd like to get some general feedback. so, in
general how big of a deal is server design? what would you use as criteria
for decision making, like the need for multiple controllers and
Create a procedure as SYS (or someone else powerful)
which does the 'alter system' and then grant just the
proc to the user
hth
connor
--- lerobe - Lee Robertson [EMAIL PROTECTED]
wrote: All,
Is there a method for allowing a non DBA user to
kill their own (and only
their own) session. I
I don't think you can kill yourself anymore, at least in 8.1.6. Even as a DBA, Oracle
wouldn't let me off myself...
Note to ALL: ENOUGH WITH THE POLITICAL CLAPTRAP ALREADY!!!
[EMAIL PROTECTED] 04/17/01 11:26AM
All,
Is there a method for allowing a non DBA user to kill their own (and only
Hello,
Li,
I
believe, stored procedure is the best and simplyest way for this purpose. There
is nothing wrong giving ALTER SYSTEM to _procedure owner_. End user will
be limited to execute this procedure only, and will not require ALTER SYSTEM for
him/herself.
Best
regards,
Vadim
how to automate CHANGE BACKUPSET key DELETE ?
Any ideas?
I'm trying to obtain the backupset key with LIST BACKUPSET, and then,
i'll need to make some script to build a rman script with several CHANGE
BACKUPSET DELETE
statements.
Am i wrong?
Thank you
--
Please see the official ORACLE-L FAQ:
My experience is that 9iAS requires 1G RAM to run well. More if you want
IFS... Given that the typical inexpensive Intel box is capped at 4GB and
Microsoft won't let you use more than 3GB (2.5 realistically) on a 4GB machine,
or half of your real RAM if you have less than 4GB, and that a
Or was it "Purity of Essence"
Protect your bodily fluids.
If you don't get the President on the phone, you'll have to answer to the
Coca-Cola Company.
A GREAT MOVIE.
Brian L. Anderson
Flunky/SA/DBA/DERT
Darton College
[EMAIL PROTECTED]
COLUMN address NOPRINT
COLUMN username FORMAT a12
BREAK ON address SKIP 1
SELECT
a.address
,sql_text
,osuser
,username
FROM
v$sqltext a
,v$session s
WHERE s.SQL_ADDRESS = a.ADDRESS
AND s.status = 'ACTIVE'
AND s.type
Try
select * from sys.v_$sqlarea
Anthony
-Original Message-
Sent: Tuesday, April 17, 2001 11:07 AM
To: Multiple recipients of list ORACLE-L
hi,
i am looking for a sql statement which can tell me the
current sql running in oracle.
TIA
Srinivas
Hi Sam,
As part of my masters dissertation I have developed an SQL monitoring tool
using Java/JDBC/thin drivers that allows the DBA to see who is taking up the
resources currently in a database.
This is not at all a commercial venture, purely
academic. Plus if you want to learn about
Larry folks,
It's taking OWS a while to clarify/answer on the question of
running db/oem/forms-server on one NT servre box (originally
submitted friday 13th).
regards,
ep
--- Forwarded message follows ---
Date sent: 17 Apr 01 10:14:44
To: [EMAIL
I think you may be trying to do a little too much with the current standby
architecture. Oracle now has product called Data Guard that will let you do
what you want. I've only read the docs on Data Guard, but supposedly you can
switch primary and standby database, and switch back without
Stephen,
Last time I checked Metalink (couple of weeks ago), 8.1.7 64-bit status was
"projected" with Sun Sparc Solaris. I filled out a TAR asking when it will
be certified, and they told me to check Metalink (even offered me walk me
though the web pages)!
Mike
The views expressed here are
All of the items are in the tables which underlie the views. Just use sql to
delete the items you want. Just be careful!
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 1:51 PM
how to automate CHANGE BACKUPSET key
set pagesize 1000
spool actual
SELECT
SID,
TYPE,
STATUS,
USERNAME,
SQL_TEXT,
EXECUTIONS,
LOCKWAIT,
SERVER,
OSUSER,
PROCESS,
MACHINE,
TERMINAL,
PROGRAM
FROM
V$SQLAREA,
V$SESSION
*** ADMIN WARNING ***
Please do not continue ANY discussions about China or the recent aircraft
collision incident in this mailing list. There have been quite a few
off-topic posts of late, but this is *FAR* off-topic, and is not appropriate
for this list. If you want to continue this
Glad to see so many people wanting to get together. I would like to
propose a time and place...
Tuesday night is the "big bash", and Wednesday night is a "Pleasure
Island" event. There is a Monday night welcome reception in the exhibit
hall until 7:45.
So, I think the best time is Monday at
Title: RE: Meeting at IOUG
I should have know Rachel would get picky.
Yes, I mean this Thursday, April 19th, 2001
R. Matt Adams - GE Appliances - [EMAIL PROTECTED]
Meddle not in the affairs of troff,
for it is subtle and quick to anger.
-Original Message-
From:
Lerone,
My opinion is that your database on an NT platform will not scale as well as
you may hope. You are talking about adding 100-150% more data and tripling
your users to 300. I would strongly recommend going to a Unix platform for
your database. Also, if the database is going to grow that
HEY! :)
Just don't want anyone to be disappointed is all
From: "Adams, Matthew (GEA, 088130)" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Meeting at IOUG
Date: Tue, 17 Apr 2001 10:45:37 -0800
I should have know
I nominate Monday evening. That way those of us who don't know anyone will have more
familiar faces the rest of the week (especially at the big bash on Tuesday).
I don't have a clue where to meet. IOUG veterans any suggestions?
Stephen Andert
--
Please see the official ORACLE-L FAQ:
its using the same engine as powerdesigner.
whats the gimmick behind this.
Story
1. Hack Bill Gates Larry Ellisons bank accounts.
2. Buy Oracle DB source licence from Oracle.
3. Write a Search and Replace globally (s/Oracle/FreeOracle/g)
4. Market FreeOracle
Just Daydreaming...
-Mandar
Margaritas? I'm there :)
Ari D Kaplan wrote:
Glad to see so many people wanting to get together. I would like to
propose a time and place...
Tuesday night is the "big bash", and Wednesday night is a "Pleasure
Island" event. There is a Monday night welcome reception in the exhibit
hall
Title: RE: ADMIN: Off-Topic (was: RE: Do not belive BUSH and your army gov
Wow, I guess Jared was fired, eh?
;-
== -Original Message-
== From: Bruce Bergman [mailto:[EMAIL PROTECTED]]
== Sent: Tuesday, April 17, 2001 2:29 PM
== To: Multiple recipients of list ORACLE-L
== Subject:
Title: Anyone out there using CA/Platinum's PR_OEE Tool?
I'd like to ask a question of you offline ( only
b/c it is likely an extremely niche-y product. )
TIA,
Ross
O.P.S. Setup in Benchmark Runs :-
--
2 DB Servers - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1
1st APP Server - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1
2nd APP Server - SUNe420R - 4 CPUs , 4 GB RAM - Solaris 2.6
3rd APP Server -
Anybody knows what is a Pleasure Island event?
Alex Hillman
-Original Message-
Sent: Tuesday, April 17, 2001 2:54 PM
To: Multiple recipients of list ORACLE-L
Glad to see so many people wanting to get together. I would like to
propose a time and place...
Tuesday night is the "big
sounds good to me any others?
From: Ari D Kaplan [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Meeting at IOUG
Date: Tue, 17 Apr 2001 10:53:57 -0800
Glad to see so many people wanting to get together. I would like to
Hi!
I'm having a problem with Oracle on Win2k here. I can't start Oracle by
using the Management Console (i.e. start the windows Service). The Service
remains in the status "starting" but never goes to "started". Then I can't
even stop the service again. Not with the tool neither with the
Bruce runs fatcity
Jared monitors this particular list
no one was fired
From: "Mohan, Ross" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: ADMIN: Off-Topic (was: RE: Do not belive BUSH and your "army"
Date: Tue, 17 Apr
I'm a first timer too. Monday night sounds good.
Jim Howerton
Senior Oracle DBA
University of Alabama at Birmingham
Health System Information Services
e: [EMAIL PROTECTED]
v: 205-934-9111
f: 205-934-0632
[EMAIL PROTECTED] 4/17/01 10:41:39 AM
I'll be there too! It will be my first visit to
Doc ID: Note:45967.1
Subject: 20 Differences Between Oracle on NT and Oracle on Unix
Type: FAQ
Status: PUBLISHED
Content Type:
TEXT/PLAIN
Creation
No offence to anyone but I enjoy being the designated driver. I have a good sense of
humor and a great time at any get-together.
Any location that the group can centrally find is ideal.
ROR mm
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET:
I'm envisioning various levels of raid just wanted to get something out
quick for some feedback. for example, I'm thinking the data files, redo
logs, arc log, and control files would be on differently combined disks.
of course some file system recovery and redundancy is desired, but to what
Pleasure Island is one of the Disney resorts
From: "Hillman, Alex" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Meeting at IOUG
Date: Tue, 17 Apr 2001 11:28:21 -0800
Anybody knows what is a Pleasure Island event?
Alex
See note 132086.1 on Metalink.
-Original Message-
Sent: Tuesday, April 17, 2001 3:02 PM
To: Multiple recipients of list ORACLE-L
Hi!
I'm having a problem with Oracle on Win2k here. I can't start Oracle by
using the Management Console (i.e. start the windows Service). The Service
Hello Leng,
1. create a hot standby from a primary database
2. activate the hot standby
3. shutdown the new primary and made a backup of the new primary
database
4. restart the new primary, created a table and create a standby
controlfile
5. shutdown the new primary
6. restore from
I'm open at 8 monday evening. Sounds good to me.
Terry
Ari D Kaplan wrote:
Glad to see so many people wanting to get together. I would like to
propose a time and place...
Tuesday night is the "big bash", and Wednesday night is a "Pleasure
Island" event. There is a Monday night welcome
Since I started this thread. Let me call for a closer. I think this
suggestion is great. Let confirm this.
Murali Vallath
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 17 Apr 2001 10:53:57 -0800
Glad to see so many people wanting to get
What is a "... Island" event? Looks like my e-mail system does not like
first word.
Alex Hillman
-Original Message-
Sent: Tuesday, April 17, 2001 2:54 PM
To: Multiple recipients of list ORACLE-L
Glad to see so many people wanting to get together. I would like to
propose a time and
thanks, but what the activities will be?
Alex Hillman
-Original Message-
Sent: Tuesday, April 17, 2001 4:11 PM
To: Multiple recipients of list ORACLE-L
Pleasure Island is one of the Disney resorts
From: "Hillman, Alex" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple
I love a good margarita (or two). Sounds like a good idea.
Bill Gentry
DBA
Allina Health System
Minneapolis, MN 55403
612-775-1190
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 1:53 PM
Glad to see so
Please forward tuning suggestions for the following problem to Oracle
Support. It looks like they may still need a little help with Metalink!
Gary
Tue, 17 Apr 2001 21:02:34 GMT
ORA-04031: unable to allocate 2550012 bytes of shared memory ("large
pool","unknown object","session heap","bind var
I am connected to an Oracle8 Database on Windows NT SP5, we have a table
with a column of datatype varchar2(4), however its length is reported as 5.
Any reason/s as to why this is happening? I have done a describe and a
select of the table below. Any help would be appreciated.
Thanks,
Susan.
Title: RE: ADMIN: Off-Topic (was: RE: Do not belive BUSH and your army
Yes, but who watches the watchdogs?
G
== -Original Message-
== From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
== Sent: Tuesday, April 17, 2001 4:06 PM
== To: Multiple recipients of list ORACLE-L
== Subject:
Hi All,
I need to move a user/schema away from the system
tablespace to a newly created user tablespace. Could
somebody point me to the references on how to do the
job? Since a production server is running off the
schema, is it possible to do the move without having
to shut down the server?
On Tue, 17 Apr 2001,Hillman, Alex scribbled on the wall in glitter crayon:
-Anybody knows if one need to rent a car there?
-
-Alex Hillman
if you are staying at the host hotels, then no... you can get anywhere
on the disney property via bus and fairly quickly. if, lik me, you are
staying at a
Title:
In retrospect, I should have made my wink alot
larger.Maybe like:
;-
well, that's about all for now.
Those rotten Republican, F-8 flying,
Chinese, Microsoft lovers can
all go to heck in a
handbasket!
== -Original
Message-== From: Eric D. Pierce [mailto:[EMAIL
Last I heard from Oracle was May 4th for release of 64-bit 817 for Solaris.
HTH
Gerardo
-Original Message-
Sent: Tuesday, April 17, 2001 8:15 AM
To: Multiple recipients of list ORACLE-L
Since we're talking 32 VS 64 bit, anybody know when
Oracle 817 64 bits we'll be available on
1. Export the user's schema ( exp help=y )
2. issue in sqlplus:
drop user_name cascade;
3. then remake the user with the new table space as the default tablespace (
all permissions there - none elsewhere ).
4. imp the user from the export dump with ignore=y
regards -
john f. lewis
And I'm just in the mood for a ramble, too...
We stayed with NT too, because we have the sysadmins and engineers already. I
have a DB that sounds a lot like yours and it's running just fine on a dual p400
with a mirror for redo and archive log and a raid5 for the data files. The real
problem
Hi All,
Further to that, it is necessary to use DBMS_SQL or native dynamic SQL for this
as PL/SQL does not support ALTER SYSTEM directly.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Wednesday, 18 April 2001
Best way is to use export/import utilities. This can be done with server on
line and you will get all table data if done at quite time when table is not
being updated. See Oracle Backup and Recovery Guide for info on exp/imp.
PA
-Original Message-
Sent: Tuesday, April 17, 2001 3:50 PM
Hello. I'm new to Oracle and am looking for some "guru" guidance on
some resources to tap in order to get up to speed (preferrably quickly).
I'm a Java programmer looking to start getting into building
applications backended by Oracle. I am comfortable with Java (including
JDBC) and SQL.
Larry folks,
Still not sure what it all means!
They don't seem to be able to answer specifically on Forms *Server*
for some reason. I'll continue asking tomorrow.
regards,
ep
--- Forwarded message follows ---
1339336.996
Open
Patricia,
FWIW, We have been using them for several months now and have not seen anything
negative as a result. We decided to start using them for all new tablespaces and we
add a new set of tablespaces every month to accomodate our partitioning strategy.
Our biggest databases that we are
Has anyone tried to use their standby database as a read-only database
through db links and mapped to synonyms? I'm having problems creating one
(12145 e.g.) and am now wondering whether it is even possible. This is to
alleviate the downtime in the event of single table failures in
On Tuesday 17 April 2001 12:15, Mohan, Ross wrote:
Wow, I guess Jared was fired, eh?
;-
Hardly. Of course, I must consider the source of this comment.
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network
1 - 100 of 106 matches
Mail list logo