Hallo,
anyone who can give me a good example of pl/sql code, which does the folllowing:
Import an excelfile into a table.
(I know I can use sqlloader(which I have used several times) but i would like to make
a call to that pl/sql procedure from MsAccess.
Thanks in advance
Roland
--
Please
Hmm,
I thought that powerpoint was the development environment for microsoft
products ;-)
Anjo.
Abdul Aleem wrote:
> I don't think so,
>
> I think they just don't know
>
> Aleem
>
> -Original Message-
> Sent: Thursday, April 18, 2002 7:53 AM
> To: Multiple recipients of list OR
I don't think so,
I think they just don't know
Aleem
-Original Message-
Sent: Thursday, April 18, 2002 7:53 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: What is Oracle made from ?
Apparently folks are bored today.
-Original Message-
Engsig
Sent: Wedne
Hi,
I tried to create a public synonym for a table in schema "inventory", but it
does not seem to be working, i.e., when I connect as another user, and try
to select from the synonym it says table or view does not exist.
I would appreciate any help.
Aleem
Following are the commands from SQL*P
Dear Guru:
I have a number of staff needs to upgrade their skills from Oracle 7.3.4 to
Oracle 8.1.7. Going to Oracle Education Center will be too expensive given
that I am looking at 7 person. Anyone have experience with electronic
training using the Oracle CD-ROM training package, NETg On-lin
Steve Adams' site is a good
start. http://www.ixora.com.au/
Tony Aponte
-Original Message-From: Anand Prakash
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 17,
2002 5:29 PMTo: Multiple recipients of list
ORACLE-LSubject: Script for identifying objects having freelists
Can you post what requiremment is driving this? I.E. Is it to be able to query for a
mixed-case input value? Maybe to sort mixed case as if it were all upper or lower?
Tony Aponte
-Original Message-
Sent: Tuesday, April 16, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L
Gree
I
think you are running into the stampeding herd phenomenon. I'm
suspicous of the low value for the spin count. It seems timid.
Could you truss one of the shadow processes with the timing option and post the
output? Just enough to identify the repeating pattern. Also, please
run the tr
Never mind. I just saw that oracle was able to
reproduce it internally.
- Original Message -
From:
Richard Eastham
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, April 16, 2002 11:58
PM
Subject: HIGH CPU WITH MULTIPLE
CONCURRENT USERS (long)
How many extents for the table?
- Original Message -
From:
Richard Eastham
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, April 16, 2002 11:58
PM
Subject: HIGH CPU WITH MULTIPLE
CONCURRENT USERS (long)
A co-worker is having a fairly serious issu
Apparently folks are bored today.
-Original Message-
Engsig
Sent: Wednesday, April 17, 2002 11:04 AM
To: Multiple recipients of list ORACLE-L
Obviously, the reality is that it is made of Powerpoint slides
On Wednesday 17 April 2002 19:28, Farnsworth, Dave wrote:
> And all this time
I was talking w/someone today, and we realized that neither
of us knows of anyone actually using RAC in production. So
now I'm curious. Is anyone?
Jonathan Gennick --- Brighten the corner where you are
mailto:[EMAIL PROTECTED]
http://Gennick.com * http://MichiganWaterfalls.com *
http://ValleySpur
Darren,
Some operating systems have file limit sizes of around 2GB so you should
check if that applies to your system.
Regards,
Sujatha
-Original Message-
Sent: Thursday, 18 April 2002 7:48 AM
To: Multiple recipients of list ORACLE-L
I am currently building a new 8i database, and hav
Hi Barbara,
I have just completed an upgrade of our production dbs from 8.0.5 to
8.1.7.3. Due to problems with our application, I actually had to migrate
from 8.0.5 to 8.0.6 first. Then as in your case, Oracle said they didn't
support migrating to 8.1.7.3 directly. So I migrated to 8.1.7.0.0 firs
Hi Marc,
No and no, as far as I know. I should double check on the user
requirements, you are right. (It would be helpful if THEY knew)
Thanks, you bring up a good point.
LK
> -Original Message-
> From: Marc Perkowitz [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 17, 2002 8:04
Darren, discuss this with your SA. There may be a limit on the os side you
need to be aware of.
Also, consider MTTR. Seems to me that MTTR won't be that different between
a 500MB file and a 2GB file.
Beyond that, it's your comfort level. Personally I like having larger files
for ease of ad
When you backup, temporary tablespace does not need to be backed up and it
is not a required tablespace for creating/bringing up database. My hot
backup does not include temporary tablespace and I was many times able to
restore/recovery the database without any problem.
-Original Message--
Do you have mainframe programs that will be brought over to use this
mainframe data? If so, they will likely have problems with nulls. If there
will only be new programs accessing this data, then it sounds fine.
Will there by any statistical work on these columns? Averages, for example,
will b
The poster implied he was going to change the
temporary tablespace to locally managed.
> > > > > to some of the other org's, so maybe staying
> > > with
> > > > > dictionary-managed would
> > > > > be
> > > > > best, except for the temporary tablespace.
> > > > >
> > > > > Darren.
All of my pr
I hope it works for
you.
set Trimspool onset Line 132set Pages
57set Newpage0set FeedBack offset Verify offset Term
offTTitle offBtime offcolumn Pct Format 990.99 Heading "%
Of |Free List Waits"column Instance New_Value
_Instance NoPrintcolumn Today New_Value _Date No
Printsel
If you use Veritas quick IO, you must use soft links.
Jared
"Koivu, Lisa" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/17/02 09:43 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Symbolic
Yes, exp/imp cleans up a lot of garbage. I always use this method.
-Original Message-
Sent: Wednesday, April 17, 2002 3:38 PM
To: Multiple recipients of list ORACLE-L
An upgrade can be seen as a rare chance to do all these things, if you
choose exp/imp method. That's what John is re
How does one destroy cookies created by an Oracle applications server without exiting
the browser? It's been a while since I tried, but several months ago, I found I could
destroy cookies that I had created, but not those created at log in. I don't want to
query these cookies just pulverize t
Because it has executed nearly 7000 times at 0.145 seconds per execution.
I would wonder why a query was executed 7000 that didn't return a result
set.
Jared
"VIVEK_SHARMA" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/16/02 09:43 PM
Please respond to ORACLE-L
To: Mult
I once heard that paranoia is a GOOD quality for a DBA.
I'm sure the person who told me that was out to get me.
|+-->
|| "Mercadante,|
|| Thomas F" |
|| <[EMAIL PROTECTED]|
|| ate
Currently we have some stored procedures that hand a ref cursor back to a
call from the Microsoft OLEDB for Oracle driver. The Microsoft driver
interprets the ref cursor as an ADO recordset and processes it accordingly.
There are a number of functions in the application that require the user to
ca
For those of you who have had to deal with data cleansing -
I am working on importing mainframe data into Oracle. This unglamorous job
involves validating (and sometimes compensating for) what is bad data in
Oracle's eyes but not on the mainframe - crazy crap like a date =
22/22/2022. I also f
An upgrade can be seen as a rare chance to do all these things, if you
choose exp/imp method. That's what John is referring to.
LK
> -Original Message-
> From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 17, 2002 5:12 PM
> To: Multiple recipients of list ORACLE-
I am not clear on what will make a fast refresh materialized view too
complex. What functions cannot be used in a FRMV that is a single table
aggregation? The following example won't work if I try to add the decode:
create materialized view log on emp
tablespace &&tbsname
with sequence, primary k
Tom,
Well you got me sort of. I ran a few quick tests on a table with 500K
rows. The return times were almost always identical. The main difference
between a Pk with a number and a char/varchar is storage. a 40 digit
number takes 4bytes of space. A 40 character string takes 10 bytes.
This trans
>From a performance benchmark prespective take a look at this:
http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp
> Well, MySQL and Oracle are very different, but there's a world of
> difference
> between MySQL and Access too. It's quite possible to use MySQL as a backend
> database for
Hi
WHat is best practices for PCTFREE,PCTUSED AND PCT_INCREASE value at object
level?
Thx
-seema
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq
Chris,
I'm rather anal about using generated keys, and *I* wouldn't
even use them here. ;)
Lookup tables with information that is likely to remain static
and have an obvious key should be fine without a generated
key. ( States are a good candidate )
Jared
"Grabowy, Chris" <[EMAIL PROTEC
I have upgraded 8.1.6 to 8.1.7.2(32-bit) on HP-UX 11.0 64-bit machine and
use LMT on all my databases. They run fine and one of the database has been
running over 1 year now.
-Original Message-
Sent: Wednesday, April 17, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L
Rafiq,
I have downloaded a trail version of Quest's Data Factory, and started
playing around with it. So I am wondering if other people have used this
product and their impressions.
TIA!!!
Chris
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Grabowy, Chris
INET: [EMAIL
On Wed, 17 Apr 2002, John Weatherman wrote:
> Clean up fragmentation/chaining, change block size at the same time,
> in my current case, chage hardware platform...
>
> All sorts of reasons. :)
What do those things have to do with an upgrade?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
You better check metalink for this one.
Cleanly removing java from a database is a rather involved
job. I've done it once, don't care to do it again.
Sorry, no pointers. It was a trial and error process with me.
There are several metalink references to it.
Jared
[EMAIL PROTECTED]
Sent b
I am currently building a new 8i database, and have the oppurtunity to
consolidate
some of my datafiles. In the current configuration I have 4 500Mb datafiles
that make up
a tablespace.
Is it okay to create a 2Gb datafile, or am I better off to create 2 1Gb
datafile's, or
stay with 4 500Mb data
Does anyone have the scripts (or URL) for identifying objects having
freelists contention?
Thanks.
Anand Prakash
Julie,
We are also going through same exercise now a days as we are moving to new
HP hardware with HP-UX 11 64 bits with Hitachi Storage. These machines do
not run on 32 bit Unix. However we are still using 32 bit Oracle and Oracle
Financials 10.7 char software.
In our situation we have to cha
My TEMP tablespace is a locally managed temporary tablespace using a tempfile (not
datafile). See results below;
SQL> alter tablespace TEMP begin backup;
alter tablespace TEMP begin backup
*
ERROR at line 1:
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
which makes perfect sense,
512 bytes
"Reddy, Madhusudana" wrote:
> I have ran this on a test database
>
> bbuxdv01:/db02/oradata/tstd1> dbfsize tstd1_1.ctl
>
> Database file: tstd1_1.ctl
> Database file type: file system
> Database file size: 232 8192 byte blocks
> bbuxdv01:/db02/oradata/tstd1> dbfsize tstd1_0101.rlg
>
>
I also remember (hopefully correctly) reading somewhere, either in metalink
or from
this list that there is a "low-level corruption" problem in
8.0.x that may causes problems when migrating to 8.1.x, by
doing the imp/exp method, you don't have to "fix" the 8.0.x database
before you upgrade.
The
FYI for anyone running Oracle 8.1.7.1, HPUX 11. Seems we are getting some
new ORA_600's at a remote site:
ORA-00600: internal error code, arguments: [kolseget623], [kolseget: index
>= max index ptr per page], [101192], [], [], [], [], []
ORA-00600: internal error code, arguments: [kolseget623],
Rafiq,
I upgraded an HP-UX 11.0 64-bit machine in early April. (8.1.6.3.0 to
8.1.7.3.0) It was the worst upgrade I've ever gone through, but everthing
appears to be running normally. (I'm not using locally managed tablespaces
yet though.) I was missing a couple of operating system patches and t
Clean up fragmentation/chaining, change block size at the same time, in my
current
case, chage hardware platform...
All sorts of reasons. :)
-Original Message-
Sent: Wednesday, April 17, 2002 3:32 PM
To: Multiple recipients of list ORACLE-L
On Wed, 17 Apr 2002, Browett, Darren wrote:
I have ran this on a test database
bbuxdv01:/db02/oradata/tstd1> dbfsize tstd1_1.ctl
Database file: tstd1_1.ctl
Database file type: file system
Database file size: 232 8192 byte blocks
bbuxdv01:/db02/oradata/tstd1> dbfsize tstd1_0101.rlg
Database file: tstd1_0101.rlg
Database file type: file sy
Fear.
I agree with you. Migrate is the preferred method in my tool-box.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, April 17, 2002 3:32 PM
To: Multiple recipients of list ORACLE-L
On Wed, 17 Apr 2002, Browett, Darren wrote:
> The previous DBA, a
Add in some wishful thinking and dreams of HUGE profits and you've got it.
Dick Goulet
Reply Separator
Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= <[EMAIL PROTECTED]>
Date: 4/17/2002 9:28 AM
Nope - there's a lot of PL/SQL and Java as well, but I know
Gene,
Nope, dead on!
Dick Goulet
Reply Separator
Author: Gurelei <[EMAIL PROTECTED]>
Date: 4/17/2002 9:49 AM
Alex,
Just wondering why do you think MySQL is closer to
Access than to Oracle. I have played with MySQL a
little and it is a relation
We have a country_code table to represent countries, but the first version
of the app is supposed to be the U.S. only version. Obviously, any
flexibility that we can design in right now can only help in the next phase.
It's the client's left hand that keeps saying this will only be used in the
U
On Wed, 17 Apr 2002, Browett, Darren wrote:
> The previous DBA, also used the export/import method, and is the method
> I am most likely going to use.
Can someone explain why anyone would opt for export/import as a path
to do an 8.0 to 8.1 upgrade? Doesn't the basic upgrade just consist
of star
-- "Weaver, Walt" <[EMAIL PROTECTED]>
> I don't think you're wrong. MySQL gets dissed frequently on this list, but
> it's really a nice little product. IMHO it's much closer to Oracle than
> Access.
>
> It works well for us. Doesn't scale like Oracle, but works well.
In some ways it scales bet
Sounds like a documentation bug in the readme. I have always patched
the software to the highest available patchset plus one-off patches,
then switched the instance to the new ORACLE_HOME and ran the upgrade
scripts.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 17 Apr 2002, Jeff
I did not say MySQL was like Access. I said it is
more like Access than it is like Oracle.
On Wed, 17 Apr 2002, Gurelei wrote:
> Alex,
>
> Just wondering why do you think MySQL is closer to
> Access than to Oracle. I have played with MySQL a
> little and it is a relational database like Oracle
I don't think you're wrong. MySQL gets dissed frequently on this list, but
it's really a nice little product. IMHO it's much closer to Oracle than
Access.
It works well for us. Doesn't scale like Oracle, but works well.
--Walt Weaver
Bozeman, Montana
-Original Message-
Sent: Wednesday
One thing to consider is country codes. I have seen many applications
where two character country codes have been crammed into the STATE_CDS
table. Usually the two character state abbreviation is the primary key,
but that means that some smaller countries end up with "abbreviations" that
have n
Lisa,
Thanks. I saw couple of messages today about problems with 8.1.7.3 on
Solaris. We are also thinking to move to 8.1.7.3 on HP-UX 11 in near future
but now we have to wait and see for a while.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PRO
That's Monkey Mama to you!!
> -Original Message-
> From: Mercadante, Thomas F [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 17, 2002 2:21 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: MySQL vs. Oracle database
>
> "From clowns to a database monkey..."
>
> L
DB2 usually means RPG which IMHO totally sucks. What OS is this for?? DB2 pretty
much runs on its own. You might get to learn all about an AS400. I agree with you
that you will be more marketable knowing more than one database. There are all types
of apps made for DB2. I don't do the DBAi
All,
Does anyone have any specific metrics demonstrating that a PK that is based
on a number field is faster than a PK based on a character field?
I've seen it mentioned a couple of times today under the "Design Question"
topic.
It doesn't make any sense to me that one or the other would be fas
The previous DBA, also used the export/import method, and is the method
I am most likely going to use.
Create the new ORACLE_HOME (8.1.7)
Patch to rev desired (8.1.7.2 or 8.1.7.3)
Export from 8.0.5
Import to 8.1.7.x
Upgrade application.
Test like crazy.
Darren
-Original Message-
Sent: A
Several people have replied back to me about the design rule to not use
business data in the primary key, which I agree with. Although I don't plan
on creating a permanent STATE_SEQ sequence, since it will only be used once
to populate the table.
Any other thoughts or arguments?? TIA!!
-
Well Chris, as you are probably aware, there is a theoretical train of
thought that says that every table should have a primary key that is an
arbitrary ID, not related to the data in any way shape or form. The benefit
is that data that is SUPPOSSED to be unique (like ssn's) can break and your
ap
"From clowns to a database monkey..."
Lisa! you got dissed!
-Original Message-
Sent: Wednesday, April 17, 2002 1:34 PM
To: Multiple recipients of list ORACLE-L
>-They don't believe in spending a lot of money on IT because
>-it hasn't paid off for them in the past and they've had
Older link but still some food for thought ->
http://openacs.org/philosophy/why-not-mysql.html
Brian P. MacLean
Oracle DBA, OCP8i
"Weaver, Walt"
On Wed, 2002-04-17 at 10:18, Grabowy, Chris wrote:
> To simplify my question, if I am creating a STATE table to hold all the
> states of the US, should I create it like this...
Chris,
We use a state_id field which is a number.Usually you want to use
numbers or integers as primary keys, but sinc
Hi Rafiq,
Sorry. I'm 8.1.7.3 on W2K. It's very possible that things have changed
drastically since last year when I created this database.
If I remember right there was an issue with export. I may be off my rocker,
because nothing is exported out of a temporary tablespace.
LK
> -Orig
Chris,
I would prefer the first method. As far as I am concerned, the only reason
to use a sequence number as a primary key is if the value for the natural
primary could could possibly change.
In this case, the two char state codes have been around for a very long time
and would probably not ch
If you go with the first option, you will likely be able to get out of
joining your STATE table to the referencing tables in a bunch of cases
(since the 2-letter abbreviation is interpretable on its own). But if
you'll wind up having to do the join anyway (e.g., to display the
STATE_DESC) then th
H
from a pure relational standpoint (something like 4th or 5th normal form),
keys shouldn't have any inherent meaning so you should go with STATE_ID as
the PK.
>From a real-world perspective, I would use STATE_CD as the PK. Its not going
to change very often (how often do state abbreviat
My fellow Databasers,
I just found out my employer has an unlimited license for DB2/UDB. I am
kind of excited at the prospect of learning a new dbms that isn't SQL
Server.
I am also feeling the need to expand my skills. Glancing at the job market
under just Oracle isn't promising right now.
There is hardly any difference, except the waste of space for the state_id.
But purists will tell you, that you should not put business information into
primary key columns, and therefore state_code should not be a primary key.
And if a state is gets a new code, it is much easier to change yo
Obviously, the reality is that it is made of Powerpoint slides
On Wednesday 17 April 2002 19:28, Farnsworth, Dave wrote:
> And all this time I had thought it was made from widgets and gizmos. ;o)
>
> -Original Message-
> Sent: Wednesday, April 17, 2002 11:03 AM
> To: Multiple recipie
Title: RE: Upgrade 8.0.5 to 8.1.7.3
Matt:
I
don't have the bug#s. When I opened a TAR on this (now unpublished) the support
person called me and told me that I had to downgrade the database to workaround
the bug. (All the TAR says is that they called me.) The analyst
said that bug is one t
Madhu,
Oracle has a fixed (at compile time) (OS) physical blocksize to work with.
That blocksize is basically the minimum blocksize the control file and the
redo log file get accessed in. So by doing 'dbfsize ' you can see
what the physical blocksize is. Or check from x$kccle. Now Veritas or the
just to one
-Please suggest if changed will be on both database what option would be
good?
--Please suggest if changed will be on one database what option would be
good?
Thx
-Seema
>From: Joe Raube <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMA
Lisa,
What version you are talking about? I am using locally managed tablesspace
with uniform extents for temporary tablespace with tempfile for last one
year with oracle version 8.1.6.2 on HP-UX 11 for datawarehouse database
without any issue/problem. Now we have migrated it to 8.1.7.2 and put
On the same server running 8.1.6.1.5 and 8.1.7.3.2.
Now ready to upgrade the 8.1.6 database to 8.1.7.
Our 8.1.7 is 8.1.7.3.2, in the 8.1.7.3.0 readme it stated: Database
Migration When migrating a database from an earlier release, for instance
8.0 to 8.1, you must complete the database migra
Alex,
Just wondering why do you think MySQL is closer to
Access than to Oracle. I have played with MySQL a
little and it is a relational database like Oracle
(not sure if access is one), uses a SQL, can have
logging and archiving just like Oracle. Again I'm not
sure whether access have all this.
Nope - there's a lot of PL/SQL and Java as well, but I know that is neither
what you meant nor what the original question was about
Rgds, Bjørn.
On Wednesday 17 April 2002 18:03, Anjo Kolk wrote:
> Nope just C
>
> Anjo.
>
> Kimberly Smith wrote:
> > I believe its C++ now but it was C.
> >
>
To simplify my question, if I am creating a STATE table to hold all the
states of the US, should I create it like this...
Name Null?Type
-
STATE_CODE
On Wed 17. April 2002 18:28, you wrote:
> [EMAIL PROTECTED] wrote:
> >What is different between MySQL and Oracle database? Someone says they
> > are the same as they are just database. From DBA or developer point of
> > view, what do you say?
> >
> >Thanks,
> >David
>
> OK, so is everybody out t
Well, MySQL and Oracle are very different, but there's a world of difference
between MySQL and Access too. It's quite possible to use MySQL as a backend
database for web hosting and get good performance and decent reliability. I
haven't heard of Access being used for that sort of thing.
--Walt We
And all this time I had thought it was made from widgets and gizmos. ;o)
-Original Message-
Sent: Wednesday, April 17, 2002 11:03 AM
To: Multiple recipients of list ORACLE-L
Nope just C
Anjo.
Kimberly Smith wrote:
> I believe its C++ now but it was C.
>
> -Original Message-
>-They don't believe in spending a lot of money on IT because
>-it hasn't paid off for them in the past and they've had clowns running
>-everything.
>From clowns to a database monkey... ;o)
Dave
-Original Message-
Sent: Wednesday, April 17, 2002 11:34 AM
To: Multiple recipients of
Check google. Anyway they are completely different. MySQL is more like
Access than Oracle.
On Wed, 17 Apr 2002, Nguyen, David M wrote:
> What is different between MySQL and Oracle database? Someone says they are
> the same as they are just database. From DBA or developer point of view,
> what
There is a world of difference between'em.
We use both here, Oracle for our large, active customers, and MySQL for our
smaller customers, to avoid as much as possible having to pay Oracle's
ridiculous licensing fees. Our smaller customers don't need Oracle's
scalability and reliability, and MySQL
David,
Yes and No in the same breath just like apples and oranges are both fruits.
Yes they are both databases and yes they both talk SQL, but that's about where
the similarities end. And before I go any further, let me say I like both of
them, for particular purposes. MySQL is nicer to de
No, it is of the most gentle substrate of the shaft of moon light.
> [EMAIL PROTECTED] wrote:
> >I believe its C++ now but it was C.
> >
> >-Original Message-
> >Xing
> >Sent: Tuesday, April 16, 2002 11:48 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Hi all,
> >
> >Just for m
Rao,
This following is the one I am seeing on my m/c
ORACLE BBED1> !df -g .
/db01 (/dev/vx/dsk/root2dg/db01): 8192 block size
1024 frag size
12582912 total blocks8284512 free blocks 7766758 available
1089844 total files
1035561 free files 53554381 filesys id
vxf
Anybody know the answer to this question? This is on HP-UX.
"I am managing a database that has symbolic links for data files. On this instance, I
am using STATSPACK to track performance. I need to tie IO rates back to real mount
points so that I can work on balancing IO.
How do I tie the na
"Oracle Database is Portable" means that it can be ported to any OS
platform. Take a full Export of the database and then use the imp utility of
Oracle to build the exact database what was there on the previous one.
If you want to import certain objects then you need to create the tablespace
wi
I wonder how many people have rushed out to do this on their production
instances now? ;P
-Original Message-
McDonald
Sent: 16 April 2002 23:23
To: Multiple recipients of list ORACLE-L
The problem can be worked around by issuing:
grant dba, select any table, select any dictionary to
pu
Hi
We have used protocol.ora successfully but that was on oracle 8.0.5
Now when we try to use the same file it doesn't allow any connections at
all even allowed hosts.
I'm not missing some config somehwere maybe in the init.ora file ?
Regards
Saj
On Tue, 16 Apr 2002, Kathy Duret wrote:
> F
Dear all,
You may get something useful to you in the following links :
http://www.orafaq.com
http://www.orafaq.com/papers/d2kinter.doc
Regds
mks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-
Hi Unal,
Here is a part of SQLNET.LOG file.
Thank You
Best Regards
Kamel Benlatreche
-
***
Fatal NI connect error 12560, connecting
Dear DBAs,
Yes I am referring to the iSQL*Plus tool available in Oracle9i. This is
also a topic of OCP 9i Exam-1. Would you please suggest some links where I
can get material in detail.
Thanks
mks
98 matches
Mail list logo
