You can always do that !!
Grant exp_full_database role to any user and he would be
able to perform full export. But.. be aware he would
also get following roles/system privileges:
SELECT ANY TABLE
BACKUP ANY TABLE
EXECUTE ANY PROCEDURE
EXECUTE ANY TYPE
EXECUTE_CATALOG_ROLE
SELECT_CATALOG_
Hello I am Kaushik Das from india .I am new to your group.
I had a query ,i hope some one will reply to this mail.
Just like we can store help of sql commands in HELP table in
oracle database.In a semilar way can we store ORACLE errors in database
for example to see oracle error in unix
You should give an EXP_FULL_DATABASE role to this user.
And of course CREATE SESSION privilege. :-)
Mike
Sinardy Xing wrote:
>
> Hi,
>
> Can I perform a full export without using System account
> If I have to create a new user to perform a full export what are the roles
> that need to be gran
yes , you can do it by granting the exp_full_database priviledge to the
user.
also the new user should need the dba role to perform such admin procedures
with more authority.
saurabh
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, March 22
Hi,
Can I perform a full export without using System account
If I have to create a new user to perform a full export what are the roles
that need to be granted ?
Thank You
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Hi,
Can I perform a full export without using System account
If I have to create a new user to perform a full export what are the roles
that need to be granted ?
Thank You
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Hi, In one of our production site, I implemented RMAN backup and recovery scripts. I
did the following way.
Take a full backup using RMAN, the following things will be backed up
datafiles,Archive logs files, controlfile. I didn't use the catalog database. I used
the database's controlfile inst
Ok, does someone one to define SRDF and BCV for
those of us that don't have any idea what you're
talking about?
Jared
On Wed, 21 Mar 2001, Koivu, Lisa wrote:
> Hi Yosi, how are you?
>
> I can't exactly clarify your fish vs. potatoes, er, timefinder vs. SRDF
> question but I can tell you that w
Hi, All,
Could someone help me to figure out the
meaning of "data block" contention in "Buffer busy wait statistics" section in
utlbstat/utlestat report.txt or "data block" class in v$waitstat?
Thanks very much in advance.
Chuan
The whole reason for multiple control files is so this is not a problem.
You simply copy the "good" control file over the "bad" control file(s) and
start up again. They are copies of each other.
-Original Message-
Sent: Wednesday, March 21, 2001 7:26 PM
To: Multiple recipients of list OR
On Wed, 21 Mar 2001, Rachel Carmichael wrote:
> help! I am by no means the world's best PL/SQL programmer (heck, I can
> barely program in it, PL/SQL 101 is on my desk at home)
>
> I am trying to see how hard it would be to add encryption to sensitive data
> in our database, so I'm playing with
yoou need to create the package -- run $ORACLE_HOME/rdbms/admin/catobtk.sql
as SYS, then you can get MY error :)
>From: "Vinod Nagaraj" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: dbms_obfuscation package
>Date: W
Check "The Data Warehouse Lifecycle Toolkit" by Ralph Kimball for the
definitive answer.
-Daniel
-Original Message-
Sent: Wednesday, March 21, 2001 7:32 PM
To: Oracledba (E-mail); ORACLE-L (E-mail)
Guys,
We r working on a Datawarehouse solution.
Our Duhvelopers want to merge all code
We have a number of Powerbuilder applications for which we have been using
the SQLCode returned from a sql statement execution to determine the next
action, depending on if the statement failed (SQLCode < 0), didn't return
any rows (SQLCode = 100) or successfully returned data (SQLCode = 0). W
It did not work that wel. Just gave the bad guys really good cover
after the noise stopped. Probably don't want to give developers that
many places to hide.
Pete Barnett
Oracle Database Administrator
Regence BlueCross BlueShield
[EMAIL PROTECTED]
On Tue, 20 Mar 2001 [EMAIL PROTECTED] wrote
Wait just a second, are you saying that "the press" (or, if
you prefer "journalistic corporate media") might be
sensationalizing things about the "bad economy" just to get
keep their readership/viewer levels high?
GASP! :)
We aren't that full of cr*p in this country, are we? :)
regards,
Actually, two questions here:
1. I have a dynamicly-built query that will be
executed using dynamic sql:
select Z, (select y from tableA t1 where
t1.id=t2.id) X
from tableA t2;
To get the value from the query, I use:
dbms_sql.column_value( theCursor, 1,columnValue);
dbms_sql.column_v
Title: RE: dbms_obfuscation package
> -Original Message-
> From: Vinod Nagaraj [mailto:[EMAIL PROTECTED]]
>
> when i run the plsql block for the encryption i got this
> error, pls tell what to
> do
>
> ERROR at line 7:
> ORA-06550: line 7, column 1:
> PLS-00201: identifier 'DBMS_OBF
Hi Steve,
I once got to work on an oil rig in the middle of Bass Strait.
The pay was based on how dangerous your work was, rather than the skill
required.
It is not often that being a DBA puts you at the bottom of the pay
scale!
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http:
We're going through a "certification" process, so to speak (offline if you're
curious), w/NetApp right now. My testing against a 100 million row (+) table
is thus far positive, but testing is really in it's infancy. A few comments:
- we're using tcp, not upd (reasons should be obvious)
- Gigabi
You can mirror the controlfiles at the hw/os level instead if you want to
protect against this.
oli
>
> I've been told a single control file failure will halt
> the database, even if you've got another control file on
> a second device; that the database will only come up again
> after editin
thanks.. I'll try this as well
>From: Vadim Gorbounov <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: dbms_obfuscation package
>Date: Wed, 21 Mar 2001 14:37:20 -0800
>
> Hi Rachel,
>I believe, this is bug. I had t
Anyone observed this on their platform ? (Observations
below are from Sun, v8.1.6 and 8.1.7)
Based on various things I've seen on the web,
immediately after startup I would expect about half
the shared pool to "kept aside" by Oracle (in the
'perm' area) and only released as memory comes under
pre
not the same errors, but at the same time, I am not giving it a proper
encryption key... I'll try that tomorrow at work and see if that changes
anything.
Thanks!
>From: "Khedr, Waleed" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED
Rachel,
Perhaps if you used Named Notation for the arguments for the
procedure, Oracle would understand which of the overloaded
procs you're calling.
dbms_obfuscation_toolkit.desencrypt
(
input_string => inp_string
,key_string => 'lksdjfasljf'
,encrypted_string => encrypted_str
)
;
L
Hey, good post. I pretty much agree with all of it except for the length
of time to fail over via ServiceGuard. It must be dependant on how much you
are failing over because ours is no more then 10 mins. for everything to
completely fail over and be running.
Are you sure that exp and imp run
> "pure Unix"
Now there's an oxymoron if there ever was one! :-)
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, March 21, 2001 2:37 PM
To: Multiple recipients of list ORACLE-L
HP-UX is the most close to pure Unix I've seen in some time.
--
Please see the official ORACLE-L FA
when i run the plsql block for the encryption i got this error, pls tell what to
do
ERROR at line 7:
ORA-06550: line 7, column 1:
PLS-00201: identifier 'DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT' must be declared
thanks
Vadim Gorbounov wrote:
> Sorry, important add-in,
> this should work too
>
>
I do not have the package installed but I found this in the DOC which may
help:
If the input data or key given to the PL/SQL DESEncrypt function is empty,
then Oracle raises ORA error 28231 "Invalid input to Obfuscation toolkit".
If the input data given to the DESEncrypt function is not a multi
Guys,
We r working on a Datawarehouse solution.
Our Duhvelopers want to merge all code tables into a single table by adding
a codetype column.
with reference to this, i came across this article from Steve's site
http://www.ixora.com.au/tips/design/meta-data.htm
i want to put them into differen
Eriovaldo,
If you don't want to have to mess around with your SQL adding chr(10), and
since you said in SQL*Plus, you could use column commands:
SQL> column dname newline
SQL> column loc newline
1* select * from dept
SQL> /
10
ACCOUNTING
NEW YORK
20
RESEARCH
DALLAS
You can
Todd,
Sorry, I spoke too soon,
we are patching to 8.1.7.0.2 on NT
MetaBlurb Quote about 8.1.7.1
"No date on Windows NT, it is still listed as delayed
HP-UX 3/23/01
AIX 3/23/01
Compaq 3/16/01 "
Sorry about the disinformation.
Scott
-Original Message-
Sent: Wednesday, March
I'm not too good at PL/SQL either and I struggled with using the
dbms_obfuscation package to create functions to encrypt and decrypt data.
We want to encrypt passwords for DBAs in a table. Now that I have the
functions they can be used for other data too. The best thing I found was a
tip by Tom K
Jared,
I wholeheartedly agree that this forum is invaluable for its
technical focus and intend to promote and support it as
such. Perhaps there have been a few too many Off Topic
postings lately. However, as wonderful and multi-faceted as
the Oracle RDBMS and its inherent challenges may be,
so
Todd,
Your skepticism is healthy, but Metalink is not:-) 8.1.7.1 is the
latest patch AFAIK.
Scott
Support Status
~~
Release Comments
8.1.7.0 Oracle8i Release 3 Base Release
See [NOTE:120801.1] if installing on Unix.
8.1.7.1 Cur
Todd,
I think you may need a vacation.
There are 8.1.7 patches on NT 8.1.7.0.1 and 8.1.7.0.2 (SQLNET Patches)
Do a search on Metablink for all NT patches and you will see a few for
Oracle 8.1.7.
Suhen
Metalink shows that there is no patch available for 8.1.7 on NT. Is that
correct or am I ne
Oracle8 8.1.7.0.2 Patch is on metalink...
it's sql*net patch...
*
i could not find 8.1.7.0.1
patrick
===
Patrick Housholder
Sr. Staff Anl Tech Spt Design
United Airlines Flight Training Center
Denver CO
*>-Original Message-
*>From: [EMAIL PROTECTED] [ma
Sorry, important add-in,
this should work too
dbms_obfuscation_toolkit.DESencrypt(
input_string => data,
key_string => key,
encrypted_string => ddata);
Vadim
-Original Message-
Sent: Wednesday, March 21, 2001 4:30 PM
To: Multiple recipient
The Continuing Story of Bungalow Bill, Lennon/McCartney, THE BEATLES (aka
The White Album).
-Original Message-
Sent: Wednesday, March 21, 2001 4:59 PM
To: Multiple recipients of list ORACLE-L
Jacques,
You're right. Preparing for a dance competition IS more challenging than DB
recover
Hi Rachel,
I believe, this is bug. I had the same problem, workaround is to create
stored procedure wrapper, not use
dbms_obfuscation_toolkit.desencrypt in anonymous block.
Another important note - both key and data lengths should be
multiples of 8.
hope this helps
If you know the character you are looking for, you can paste it into
a script like the one below, to quickly fix specific tables and columns.
update table
set column_name= replace(column_name,'û',null)
where column_name like '%û%'
/
You can use ' ' in place of null if you really want a blank in
I'll try here to answer two posts at the same time thereby saving a little.
HP-UX is the most close to pure Unix I've seen in some time. My experience with
Solaris is very thin and although it appears very stable I think there are a
number of commands that just don't work like the standard says
Title: RE: 1/2 control file failure - will database halt?
Yea,
it worked for me... it was a small database
-Original Message-From: Kevin Kostyszyn
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, March 21, 2001 4:30
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
1/2 c
I don't believe there is a patch yet. I am waiting for it so they can fix
that wonderful cursor_sharing bug that has been around since 8.1.6.
Kev
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, March 21, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L
Metalink shows that th
Title: OFF TOPIC: DBA Job at a Chocolate Factory
Jacques,
You're
right. Preparing for a dance competition IS more challenging than DB
recovery - my wife and I rehearse somewhere between 400 and 600 hours/year to
dance a total of maybe 45 to 90 minutes in each of our four annual
competitio
If you have a single corrupted database, replace the bad copy with the good one and
restart the database. You should only have to modify the init.ora if the location of
the corrupted or missing control file is not reachable. Each control file contains the
exact same information. You have multip
Title: RE: 1/2 control file failure - will database halt?
So you
don't bring the DB down and then copy the controlfile? You just copy
it? Just curious
Kev
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent:
Wednesday, March 21, 2
Metalink shows that there is no patch available for 8.1.7 on NT. Is that
correct or am I needing a vacation? I hate to be cynical, but an Oracle
product with no patch for 3 months? This I find hard to believe.
Todd Carlson
Oracle 8 & 8i Certified DBA
Bunge Corporation
--
Please see the official
Thanks again Jack.
> It would be better in the long run (maybe even the long raw
> run!) if you used a BLOB. That way the features of the
> DBMS_LOB package would be available to you, not to mention
> out-of-line storage options galore.
I'm aware that LONG eventually will be discontinued - any
help! I am by no means the world's best PL/SQL programmer (heck, I can
barely program in it, PL/SQL 101 is on my desk at home)
I am trying to see how hard it would be to add encryption to sensitive data
in our database, so I'm playing with DBMS_OBFUSCATION_TOOLKIT.
I created a table:
SQL> des
Subject line got your attention didn't it?
Some may recognize that line from a Bill Cosby routine.
I thought it might be an attention grabber.
-- the real purpose of this post
Lest we all forget the purpose of the this forum
and others like it, I am posting some comments
that were sent to me.
Hi all,
I think this thread was talked about a few days ago, but I missed it.
Can anyone show me how or where to look to call a unix script or other
program
from a stored procedure.
Thanks
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bartolo, David
INET:
Title: RE: 1/2 control file failure - will database halt?
Dana,
The database will spit errors. I found as long as you are only reading data and not trying any DDL or stuff like that, for the most part the database will continue to run. As the DBA, if you rush in and copy one of the contro
Steve Orr wrote:
>
> Now how did I know you would say that? :)
> Sometimes we're crazy like a fox... mostly we're just crazy. :)
me, i got the papers to prove it too.;-)
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc [EMAIL PROTECTED]
--
On Wed, 21 Mar 2001, Shakeel Qureshi wrote:
> Hi Jared,
>
> Its Oracle 8i and just need to do this operation on
> a small table, using SQL and PL/SQL.
>
> I would appreciate if you could guide me
>
> a. As to how to find out the special characters
> b. Change values
>
> Looking forward to you
Nihar,
1. create new entries in the /etc/oratab and listener.ora files for your new
instance, setup environment variables for the new instance : ORACLE_SID
should be set to the new instance name, ORACLE_HOME to your existing Oracle
home dir.
2. Then just create the new database with these new se
It's all "accounting" and "Wall street analysts". Most accountants I know can't
keep their own check books balanced and I've got an old class mate down in a
wallstreet brokerage. He does petrochemical companies. What I don't understand
is how he got the job as he flunked chemistry in HS, and I
"Armstead, Michael A" wrote:
>
> I also had a chance to work for a company that operates music stores. That
> company was probably very much like your chocolate company, but with music.
> Everyone had offices and each office had stereo equipment. Each week, a memo
> would come out listing the mo
Morten,
You're safe. Since each User Session runs its own
instantiation of each trigger and gets its own instantiation
of the PL/SQL table, they're totally isolated from one
another and don't interfere with each other at all.
That's why a PL/SQL table is better than a DB table for
storing After
Well hell, the most important one was the 64-bit. Its the same
on HP. Its to allow for extra. In other words things like a
bigger SGA and what not. I really don't care what export runs
at as long as it runs. That being said, with the exception of
one database I am keeping them at 32-bit.
---
Title: RE: multiple instance
> -Original Message-
> From: Nihar [mailto:[EMAIL PROTECTED]]
>
> how to create multiple oracle 8 instances on solaris.
Do you want to test Oracle Parallel Server by having two OPS instances accessing the same database on the same server? Or do you wan
Now how did I know you would say that? :)
Sometimes we're crazy like a fox... mostly we're just crazy. :)
Steve
-Original Message-
Carmichael
Sent: Wednesday, March 21, 2001 11:38 AM
To: Multiple recipients of list ORACLE-L
Steve,
I don't think you're crazy..
I know you are :)
I also heard (anecdotally), that Oracle had no long term debt and little
short-term debt, so their profits aren't going to service debt, and that
they had a pretty big chunk of cash just lying around.
Dan
-Original Message-
Sent: Wednesday, March 21, 2001 2:45 PM
To: Multiple recipients
I've been told a single control file failure will halt
the database, even if you've got another control file on
a second device; that the database will only come up again
after editing the init.ora to remove the reference to the
faulty control file and initiating a fresh startup.
Is this still t
aren't there some people from north carolina here? know any local, in
state, oracle training outfits?
===
Lerone Streeter
System Analyst
Abbott LBG
[EMAIL PROTECTED]
===
--
Please see the official ORACLE-L FAQ: http
Here is something a friend of mine sent me today, just to show how
impossible it is to get consensus on history:
Hahahahahahaha. He is so right. I guess our Ministry of
Propaganda will have to do a little research before they create the next
rant. Also, Lacrosse is Canadian by
Great question!
I had an opportunity to work at the Longaberger Basket factory. They
hand-make baskets that are sold through multi-level marketing, like Avon and
Mary Kay Cosmetics. The factory is very nostalgic. The company is the only
company in the one-horse town of Dresden, Ohio. They even ha
isn't that a bit of overkill?
select column1||chr(10), column2||chr(10),. from table;
should do it
>From: "Trassens, Christian" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Easy Doubt in sql/plus
>Date: Wed, 21
Title: RE: Data into another table
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> How can I create a select statement from table1 including
> some division or multiplication , and then include the result
> into table2.
Dear Mr. Sköldblom,
I see yo
No, using only one statment select like
select * from tab,
what can i set before ?
Eriovaldo do Carmo Andrietta
[EMAIL PROTECTED]
ICQ #102604225
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 3:20 PM
With subquerie
This Metalink doc has what you're looking for
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1008866.6
Harsh Agrawal wrote:
>
> Hi,
>
> Can u help me to knoe what are the init.ora parameters contributing
> these ?
> Pl. give one to one or one to
HI...
Last year around this time, we were working on
Solaris 2.7 (64-bit) and Oracle 8.1.5 (64-bit)
and were shocked to find that apart from
Oracle executable very few executables (like exp/imp)
were 64 bit!
Because of this we abandoned the idea of 64-bit with digust!!!
Can you please tell me h
WOW, in addition to protesting the sale of indulgences and trying to reform
The Church, and printing a Bible, he had time to bowl too?
Dan
[Henry sent]
Did you know Martin
Luther was an avid bowler?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dasko, Dan
INET: [E
But all is not gloom and doom for Oracle. Excerpts from Chuck Phillips of Morgan
Stanley on the last quarter
It's useful to keep the quarter in perspective.
It's a miss but not a financial disaster:
- Oracle made $900 million in operating profits in the quarter. This is
real busi
We use ServiceGuard here as well on HP-UX. We do not use OPS and I think
ServiceGuard works great.
Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, March 21, 2001 10:29 AM
To: Multiple recipients of list ORACLE-L
Subject:
That's the story. They even have a lifesize model.
-Original Message-
Sent: Wednesday, March 21, 2001 1:52 PM
To: Multiple recipients of list ORACLE-L
WOW, in addition to protesting the sale of indulgences and trying to reform
The Church, and printing a Bible, he had time to bowl too?
I've always been a good little girl wouldn't have touched anything...
and I am definitely NOT that spoiled little bratty girl!
>From: "Mohan, Ross" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: OFFTOPIC RE: Rachel an
Steve,
I don't think you're crazy..
I know you are :)
Actually I would turn that job down, if only because it would make me crazy
to be around the chocolate and know that eating it would make me unfit to
work
Rachel
>From: "Steve Orr" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>
Title: OFF TOPIC: DBA Job at a Chocolate Factory
> -Original Message-
> From: Jack C. Applewhite [mailto:[EMAIL PROTECTED]]
>
> Now MY idea of a heavenly DBA gig would be at something like
> the Fred Astaire or Arthur Murray World Headquarters, where
> my wife and I would have access
I think, your library path is not set correctly.
(ksh)
In sun
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
In HP
export SHLIB_PATH=$ORACLE_HOME/lib
IN AIX
export LIBPATH=$ORACLE_HOME/lib
and then try again...
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.
Should I be SYS or SYSTEM user
when exporting the entire database?
Help!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leyden, Joseph
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
Eriovaldo,
Try this...
Select Col1 || Chr(10) || Col2 || Chr(10) || Col3 || Chr(10)
|| Col4 As TheList From Table;
Results...
THELIST
---
Value of Col1
Value of Col2
Value of Col3
Value of Col4
Jack
Jack C. Applewhite
Database Administrator/De
Thanks for the prompt tip Jack, it works! :) Are there any caveats?
How about concurrency? As it is now, I insert into the PL/SQL table
using
v_Index := NVL(UpdatePackage.v_IDs.LAST, -1);
v_Index := v_Index+1;
UpdatePackage.v_IDs(v_Index) := :new.id;
within the row trigger. In the statem
Yeah, scofflaw seems to be a common ailment among presidential types. Our current
prez is no stranger to the handcuffs either and he and the veep total 5 arrests
between them.
Jim
>>> [EMAIL PROTECTED] 03/21/01 12:56PM >>>
I had a short gig setting up a database in Tallahassee State prison.
I get a 'not found' when I try to run it on AIX. RBG
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 12:02 PM
> Under unix (Solaris at least): set your oracle environment and run
> $ORACLE_HOME/bin/sysresv.
> No idea ab
Title: RE: Locking
> -Original Message-
> From: Richard Lau [mailto:[EMAIL PROTECTED]]
>
> Recently, one of my users nor I could update a table. As I
> dug around, I
> couldn't find any of the 'lock' tables such as dba_locks.
> Eventually, I
> managed to start data gatherer and
How about
ipcs -mb |grep oracle
It will give you more condensed info about usage of shared memory segment.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 21 Mar 2001 09:02:53 -0800
ipcs -b should give you details of shared me
System is fine.
--- "Leyden, Joseph" <[EMAIL PROTECTED]> wrote:
> Should I be SYS or SYSTEM user
> when exporting the entire database?
>
> Help!
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Leyden, Joseph
> INET: [EMAIL PROTECTED]
>
> Fat City Network Se
Title: RE: Data into another table
In my last sentence, I meant SALES! I do not profit from any book SALES made by fatbrain(tm).
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> How can I create a select statement from table1 including
> some division
Steve,
I don't about unique, but variety is what I enjoy. I've worked at a bank, mortgage
bank, diesel engine sales and service, city government and am currently working for an
insurance company.
Stephen Andert
>>> [EMAIL PROTECTED] 03/21 9:06 AM >>>
Seven years ago I was offered an Orac
> DBA who was in for 10 years for 3 counts of assault and battery...
He must have been working with a lot of duhvelopers. ;-)
-Original Message-
Sent: Wednesday, March 21, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L
I had a short gig setting up a database in Tallahassee State
Title: RE: DBA Job at a Chocolate Factory
I once did a 6 week emergency fix/port at a company called
Midwest Labrotories. They did environmental testing of things
like water, air, soil, food, plants, etc.
The worst part was that every other Thursday (or thereabouts)
was 'manure day'. The
You should be a user who has export_full_database and import_full_database
to export and import.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 1:35 PM
> Should I be SYS or SYSTEM user
> when exporting the entire
Ang man...ugh...ers.
--- Steve Orr <[EMAIL PROTECTED]> wrote:
> > DBA who was in for 10 years for 3 counts of assault and battery...
> He must have been working with a lot of duhvelopers. ;-)
>
>
> -Original Message-
> Sent: Wednesday, March 21, 2001 9:56 AM
> To: Multiple recipients of
hi folks
how to create multiple oracle 8 instances on solaris.
regards
- NIHAR SANGHVI
NetMagic Solutions Pvt. Ltd.
22,Nirlon Complex,Western Express Highway,
Goregaon (E), Mumabai 400 063
Phone: 8723003 extn: 144
www.netmagicsolutions.com
--
Please see the official ORACLE-L FAQ
In svrmgrl, executing
oradebug ipc
will generate a tracefile with the information required for mapping it
with the output of ipcs.
Regards,
Denny
Ruth Gramolini wrote:
>
> Me too!
>
> Thanks,Ruth B. Gramolini
> ORACLE & DB2 DBA
> VT Dept. of Taxes
> ph# 802.828.5708
> fax# 802.828..
HI...
Last year around this time, we were working on
Solaris 2.7 (64-bit) and Oracle 8.1.5 (64-bit)
and were shocked to find that apart from
Oracle executable very few executables (like exp/imp)
were 64 bit!
Because of this we abandoned the idea of 64-bit with digust!!!
Can you please tell me h
--- Forwarded message follows ---
Date sent: Mon, 19 Mar 2001 02:04:08 -0500 (EST)
...
***
$1 Billion Savings Gets Even Less Likely For Oracle
Oracle's goal to reach one billion dollars in savings by implementing
its own fi
SELECT column1||chr(10)||column2||chr(10)||columnN
from table;
Rick
> -Original Message-
> From: Eriovaldo do Carmo Andrietta [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, March 21, 2001 1:03 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Easy Doubt in sql/plus
>
> Hi Fri
Ruth,
In the trace file. You run it on a 8.0.X.
Regards.
> -Mensaje original-
> De: Ruth Gramolini [SMTP:[EMAIL PROTECTED]]
> Enviado el: miércoles 21 de marzo de 2001 18:46
> Para: Multiple recipients of list ORACLE-L
> Asunto: Re: identifying shared memory segments
>
> Walt
1 - 100 of 185 matches
Mail list logo