Gregory Conron schrieb:
On June 16, 2001 04:35 am, Jared Still wrote:
Many of
us consider this a service, especially the way that jobs are
at the moment.
Amazing the difference a year can make, eh?
Hi
Just curious: How bad is the job situation in the US right now ?
I'm wondering
Hi List Members,
I wonderif preceding ORACLE-L messages
are kept.How can I reachall messages
that have been sent to the list up to now?
BURCIN USTUN KILIC
Dear All,
Is there a recommended approach on how to decide on the db_block_size for
your database? I am looking to create a database that during the day will
be used for light OLTP, but during the day and night will have heavish batch
jobs. Therefore I was intent on using 8k or 16k blocks.
What I mean is our database can not startup anymore...some datafiles are
missing..
m-t-x
Our greatest glory is not in never falling but in rising every time we
fall
-Original Message-
Sent: Tuesday, June 19, 2001 11:57 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
A broken
Thanks Rajesh,
The part of broken database is datafiles (data-datafile and control-file).
It caused by immediate shutdown from electricity consumption. And affect the
database (corrupted).
We have online backup..including archive log.
OS = HP-UX tester B.10.20 E 9000/802 1414693381 8-user
Hi,
If you spool the files from sqlplus you can add the following lines of code
column datum new_value datum noprint
select to_char(sysdate,'ddmm') datum from dual;
spool file_name_datum..lst
Jack
Hi Alex,
I am relatively new to the world of Oracle so I would
appreciate it if you could elaborate more on the
subject. I downloaded a jdbc driver from oracle.com but
I am not sure where to place it or how to use it. I
tried to use the Oracle JDBC OCI-8 driver type when
creating the
Title: RE: How to size db_block_size?
Hi Justin,
A larger data block size provides greater efficiency in disk and memory I/O (access and storage of data). Such cases include:
a) Oracle is on a large computer system with a large amount of memory and fast disk drives. For example, databases
Dear DBA Gurus,
I need to find the size of one row of all the tables under a particular
schema using vsize clause. How do I do this? Please help.
TIA and Regards,
Ranganath
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ranganath K
INET: [EMAIL
Hi,
set colsep ';' (or whatever you want)
set pages 0 (to avoid headers)
set lines 2000 (or at least high enough)
set trimspool on (trims trailing blanks while spooling)
spool output.lst
select * from table;
spool off
Dear DBA Gurus,
Assume I have an emp table under Scott Schema with the following structure.
Name Null?Type
- -
---
EMPNO NOT NULL NUMBER(4)
ENAME
Well, you'd want your database block size to be an integer multiple of
your file system block size, to minimize I/O, because Oracle reads and
writes in blocks, if there is any overlap that means you are using an
file system level I/O for a partial block. I remember hearing that
Oracle were
http://www.ixora.com.au/tips/creation/block_size.htm
provides a good explanation of how and why to select a large db block size//
--
From: Nirmal Kumar Muthu Kumaran[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 3:30 PM
To:
Title: RE: How to size db_block_size?
Hi all,
just want to ask,
How do we know the OS Block size from our system
?
We use Sun Solaris 2.7
any command to show OS Block Size ?
Thanks Regards
Herman
- Original Message -
From:
Nirmal Kumar
Muthu Kumaran
To: Multiple
Hi all,
I recreated DBA role that provided by Oracle8i,
1. Create New_DBA_role identified by change_me;
2. Select 'GRANT ' || privilege || ' TO new_dba_role' FROM dba_sys_privs;
Create new dba user
3.Create user new_dba identified by password
default tablespace userdata
Hi
Someone posted the address of the oracle ftp site a while back. As I've
forgotten it, could they repost it.
TIA
David Lord
Senior DBA, Hays Commercial Services, IT Solutions
**
This email and any files transmitted with it
hello Siva,
You can concatenate raw SQL_TRACE files as a single file, then upload this
file to itrprof.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 2:30 AM
Hello Gurus,
I was trying to pull distinct sql's and their
Then there's our good friends at Siebel, who are
telling us Yes, we do say 96M for the PC client in
the manual, but we really mean 256M, and 512M ideally
Hello ? Earth to Siebel ?
--- Mohan, Ross [EMAIL PROTECTED] wrote:
Well, maybe I am smoking crack, but Win2K Pro
is running dandily on my
Sounds to me like most of your database objects are in
SYSTEM tablespace (ie SYS1ORCL.ORA).
Try
select owner, tablespace_name, count(*)
from dba_segments
group by owner
If you've got lots of things in SYSTEM that are not
owned by SYS, SYSTEM then its
a) time to fix a lot of this up
b) get a
Title: RE: How to size db_block_size?
Just one thought.
You check the block size of redolog files using
following
script ( -- Author:Steve
Adams)
select max(l.lebsz)
log_block_sizefrom sys.x$kccle lwhere
l.inst_id = userenv('Instance')/
This would give the OS Block Size. I
am
Hi folks.
I'd like to know about different latchs, wait events and locks.
Meaning of willing to wait and immediate ratio and all anothers things in
relation with that.
Anybody knows about documents, books, notes in Metalink, etc about
that?.
Thank you very
the best resource ..
http://www.amazon.com/exec/obidos/ASIN/156592598X/ixora/102-4862016-6200168
--
From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 5:55 PM
To: Multiple recipients of list ORACLE-L
machine:
celeron 450Mhz, 256M of ram, 512M of swap.
it installed, yea.
Here are the problems:
1. do not even attempt to run the gui tools(dbca, netasst) with the
install, it will bomb.
2. none of the binaries will link, just click ignore for all of the
errors, we will deal with them later.
Dear Seema,
If you take export using sys user you will be exporting the base
tables also which is not good when recreating your database from scratch
and using import to transfer database accross. To avoid this we use the
system user which only exports the views and not the base
ftp://oracle-ftp.oracle.com ftp://oracle-ftp.oracle.com
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes
Is there anybody who knows about Smart Array 12000
disks.
I need to install datafiles on these disks . Is it
a RAID5 system?
Philippe,
If you have a large rollback segment that you want to use for a particular operation
you can use the SET TRANSACTION USE ROLLBACK SEGMENT xxx command to assign the use
of a rollback segment.
To make sure you are the only operation using it, set it offline first and wait for
the
Are you talking about the Metalink ftp site?
If so, it is 205.227.44.220
Sign on as anonymous with the password as your email address.
-Original Message-
Sent: Tuesday, June 19, 2001 5:47 AM
To: Multiple recipients of list ORACLE-L
Hi
Someone posted the address of the oracle ftp site
Then I strongly encourage you NOT to use the EXTEND clause or the Storage
Manager to extend the size of those big files.
Instead, if you have to extend them, create a second file.
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des
DBA jobs listings on ComputerJobs.com for the Florida area have gone from 1572 to
846 over the past 6 months. The job ads you see are repeated each week and are posted
by more than one recruiter for the same job. Contact with the recruiter results in the
job is filled or some other lame
Help anybody, version 8.1.6.3 on UNIX
1. Storage clause of an intermedia index build. How
to specify the buffer pool to KEEP or CACHE the index?
2. How to specify the tablespace for such a DOMAIN
index. When put in tablespace clause, says its invalid
option for domain index.
Thanx
=
I would recommend adding where owner not in ('SYS','SYSTEM') cause those you
cannot control.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Tuesday, June 19, 2001 5:56 AM
why not analyze the table and look at avg_row_len column on
user_tables?
joe
[EMAIL PROTECTED] 06/19/01 04:30AM
Dear DBA Gurus, I need to find the
size of one row of all the tables under a particularschema using vsize
clause. How do I do this? Please help.TIA and
Regards,Ranganath--
os :WINDOWS
ADVANCED SERVER 2000
DB: ORACLE 8.1.6
MY question is how to execute a script on each
startup of database on NT ??
Thanks
Bunyamin
Thanks all, I'll remember to bookmark it this time.
David Lord
-Original Message-
Sent: 19 June 2001 13:05
To: Multiple recipients of list ORACLE-L
ftp://oracle-ftp.oracle.com ftp://oracle-ftp.oracle.com
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin
Dear List,
What the difference between qio and direct I/O
option in Veritas file system VxFS??
KC
Florida has always been a weak market compared to rest of the USA. I remember in NYC,
you could go get another job at a lunchtime interview. DC area has a good job market.
Pick up the NY Times or Washington Post. Not sure on the rest of the country. BTW,
the financials job in Miami is at
There is a wealth of docs regarding this issue in OTN
also check
http://www.oracle.com/products/intermedia
-Original Message-
From: Oracle DBA [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 15:11
To: Multiple recipients of list ORACLE-L
Subject: Intermedia Questions,
Title: RE: Intermedia Questions, Any Gurus on This Subject?
Hi Vicky,
You need to create a preference to define the storage clause with CTX_DDL. I did this at a former employer and I don't have the scripts handy, sorry to say. The documentation does go over this in detail. You can specify
The Minneapolis / St. Paul area is not very active for
Oracle people now. We have about 175 Oracle shops in
the area.
Ken Janusz, CPIM
Florida has always been a weak market compared to rest of the USA. I remember
in NYC, you could go get another job at a lunchtime interview. DC area has
'''joy'''
-Original Message-
Sent: Monday, June 18, 2001 6:25 PM
To: Multiple recipients of list ORACLE-L
Hi,
I have a column defined as varchar2..i need to insert name like 'joy' in
it with quote
how can we insert quote(') to column.
Thanks
Harvinder
--
Please see the
Does anyine have a current link to the VNC binaries for AIX 4.3? The link documented on the VNC home page at ATT Cambridge Labs is a dead URL.
Regards,
Gary
_
Good judgement comes from experience.
Experience comes from bad judgement.
__
We do it
Oracle8i Internal Sevices
by
steve Adams.
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Latchs
Date: Tue, 19 Jun 2001 02:55:21 -0800
Hi folks.
I'd like to know about different latchs, wait events and
I don't think BSIDBA and OPS$BSIDBA are the same Oracle user. (Check in
dba_users). So ops$bsidba probably doesn't own the tables? (Maybe the install
went wrong because of the value of the initializaion parameter
os_authent_prefix which I think could be null or could be ops$ or some other
This is interesting, at home I received an e-mail from a recruiter from
Florida, who said that he had hundreds of positions to fill, etc. etc.
I just answered: if this is not spam, let me know.
He replied: It's not spam!!
But I strongly suspect that he is in fact just building a database of
Hi all,
I have a question wondering if someone could help me out. Has anyone heard
of compatibility issues with Jdeveloper 3.2.3 on Winnt and versions of
Oracle DB's. I have someone here telling me that it won't work with Oracle
8.1.6 SE, and it is causing me MAJOR issues. So if anyone
Dear List,
Someone told me when a disk receive a
write request, it write to the nearest free space on disk where the disk
read/write head is currently positioning, is this information correct?? If this
is true, is this a bad thing for database application?? That mean we can't
really
Sorry, this might be a stupid question but, is the db ON the same machine as
JDeveloper. If it is, are you sure the db is running, is the machine on a
network? If it isn't, were there any errors encountered during
installation?
-Original Message-
Mouchantaf
Sent: Tuesday, June 19, 2001
You need to create preferences to specify storage parameters like:
begin
ctx_ddl.create_preference('storage_small','BASIC_STORAGE');
ctx_ddl.set_attribute('storage_small','I_TABLE_CLAUSE','tablespace
LOBADM_01_SMALL_DATA');
ctx_ddl.set_attribute('storage_small','K_TABLE_CLAUSE','tablespace
http://www.uk.research.att.com/vnc/
is up and running for me.
Jon Baker
Database Engineer (1/5)
[EMAIL PROTECTED]
www.netsec.net
[EMAIL PROTECTED] wrote:
Does anyine have a current link to the VNC binaries for AIX
Also look for Anjo Kolk's (sp?) paper Oracle7 Wait Events and Enqueues on
http://www.evdbt.com
Scott Shafer
San Antonio, TX
210-581-6217
I hate the country, all those animals walking around un-cooked.
-Original Message-
From: Rahul [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, June 19,
Joe,
Did you get time to do your RH Linux tests this weekend? If you're in
Dresden, you probably didn't have much else to do. If you did test, how'd it
go?
Michael Armstead
Application Database Administrator, OCP-Certified
US Pharmaceuticals IT
Glaxo SmithKline
-Original
Hi
Do you know what is meen:
ORA-29547 Java system class not available: oracle/aurora/rdbms/Compiler
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alon Ben-Zvi
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
opportunities are scarce in all facets of computing across the US, yes it is
amazing the difference a year can make. a friend sent this link the other
day:
http://www.salon.com/tech/wire/2001/06/15/new_homeless/index.html
I've got friends in Atlanta, Detroit, san Francisco, new york, and a few
yea got it installed on 256M of ram last night,
there is another msg on the listserv about my findings, if you
dont see it let me know and I'll resend it from home tonite.
basically, i got the binaries installed(but none of them would
relink),
hacked the $ORACLE_HOME/bin/genclntsh based
Hello,
If you have the NT Resource Kit check out AUTOEXNT
The AutoExNT service allows you to start a batch file, AUTOEXNT.BAT, at boot
time without having
to log onto the computer on which it will run.
AutoExNT includes an /interactive option (analogous to the /interactive
option of the AT
As
that person if Santa exists.
The
datafiles allocate their extents upon their creation, so a new insert will write
within that space,
"Walking on water and developing software from a
specification are easy if both are frozen."
Christopher R. Spence Oracle DBA Fuelspot
It all
depends on what kind of os/filesystem/and disks you have. I know
that under AIX, using SSA drives we could actually tell where on the disk we
wanted the filesystem to go. This way we could position certain things in
the faster location.
But
personally, I would not go thru the
From MetaLink
Do the following
Set the CLASSPATH to ORACLE_HOME/javavm/lib/aurora.zip
Then run the initjvm.sql script from
ORACLE_HOME/javavm/install.
Rick
-Original Message-
Sent: Tuesday, June 19, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L
Hi
Do you know what
Hi
Do you know what is mean:
ORA-29547 Java system class not available: oracle/aurora/rdbms/Compiler
Thanks
I have used SelfTest Software in the past to prepare for
the OCP tests. Is there another similar company that is
as good or better?
Thanks,
Ken Janusz, CPIM
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services--
Title: RE: How to size db_block_size?
ok I'm
confused.
if i
run df -g i get this
(/dev/vg00/lvol3 ) :
8192 file system block size 1024 fragment size
and if i
run
select max(l.lebsz)
log_block_sizefrom sys.x$kccle lwhere
l.inst_id = userenv('Instance');
i
get
LOG_BLOCK_SIZE__
Alon,
Sounds to me like you're missing the classesXX.zip file in
$ORACLE_HOME/wherever_you_defined_the_lib
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
It means that the Java system classes aren't installed. Try logging in
as SYSTEM and running CREATE OR REPLACE JAVA SYSTEM. This will take a
while, but it should fix your problem.
g.
-Original Message-
Sent: Tuesday, June 19, 2001 4:56 PM
To: Multiple recipients of list ORACLE-L
Hi
Hi
Is there any way to find which process is taking much cpu except top command
on Solaris Unix.
If some one have any script let me know.
With regards
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
http://www.theregister.co.uk/content/2/19805.html
http://www.theregister.co.uk/content/2/19805.html
Compaq Alpha box steals 9i benchmark laurels
By Andrew Orlowski in San Francisco
Posted: 19/06/2001 at 11:49 GMT
Title: RE: * I'm Looking for an Oracle Financials DBA for Miami,
I also
think that, if you are willing to move, Oracle DBA's can ALWAYS find
jobs.
Move
to either large population areas where either Federal or State Govt's are, and
there always consultant opportunities.
I
can't imagine
/usr/ucb/ps -uax
This will give u the /son of a b***'s' taking the most CPU
Sam
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 9:13 PM
On Tue, Jun 19, 2001 at 08:46:04AM -0800, Seema Singh wrote:
Hi
Is there any
hi
i accidentally dropped duel table from sys..then recreated it.
now when i am using rman during running the catrman.sql for recovery_catalog
it is flashing error
select '08.00.05' from dual
*
ERROR at line 2:
ORA-00942: table or view does not exist
u'r help is highly appreciated
Shirish
Title: using User defined functions in Check constraint
Hussain
While
you can use any Oracle supplied function within a check constraint, you cannot
use a self-written function.
But
you can perform the same thing by using a database table trigger on the table
itself. You can basically
use the following command it will tell who is using the cpu
/usr/ucb/ps auxw|head
From: Seema Singh [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: how to find highest process useing more CPU
Date: Tue, 19 Jun 2001 08:46:04 -0800
I've bumped into a problem with Reports 25 designer:
When I try to load an rdf or rex into the database, the application dies.
On my NT box, if I use r25mov32.exe or r25con32.exe, I get:
REP-26540: Abnormal condition: Internal error while reading
SQL*Reportwriter V1.1's Rexfile
If I use
Make sure you grant select from dual to public.
HTH,
-Rocky
--- Shirish Khapre [EMAIL PROTECTED] wrote:
hi
i accidentally dropped duel table from sys..then recreated it.
now when i am using rman during running the catrman.sql for
recovery_catalog
it is flashing error
select '08.00.05'
my guess is the public synonym is still there, grant select on dual to
public.
if the synonym isnot there recreate it also.
joe
[EMAIL PROTECTED] 06/19/01 01:51PM
hii accidentally dropped duel table from sys..then
recreated it.now when i am using rman during running the catrman.sql for
Who were you logged on as when you recreated it? Did you create a public
synonym for user.dual? You should create the table as sys.dual and create
the public synonym for it. That should fix your problem
HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
All,
For a position that would (possibly) like me to set up an
Oracle infrastructure from scratch, on Unix. Given the
opportunity to choose from any system, what hardware
would you pick?
From the small bit of information I've been able to glean,
it'll be fairly large, and need failover.
I
hi,
do you know how to hide oracle passwords from ps -ef? we pass in our pw in
cron, and it shows up when you run ps -ef (to check unix processes). i
recognize that is this NOT a smart thing to do...
can anyone recommend a better way of supplying oracle passwords when
scripts are connecting
And one more thing. The table dual has one column called dummy with is defined as
varchar2(1). and contains ONE row with the value of 'X'.
[EMAIL PROTECTED] 06/19/01 02:13PM
Who were you logged on as when you recreated it? Did you create a public
synonym for user.dual? You should create the
That would be good advice also for people form New York and / or California that might
be interested in migrating to the USA for work also, with all the dot com layoffs.
Check
www.monster.com
www.dice.com
www.net-temps.com
for jobs positions and put your resume to see response before
You could always just run catalog.sql as sys.
-Original Message-
Sent: Tuesday, June 19, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L
Your email says duel. You created dual, with an a, right?
And did you grant select on dual to public? And create a
public synonym for it?
We recognized the same problem and found this program as an answer:
http://www.orafaq.org/scripts/c_src/hide.txt
Michael Armstead
Application Database Administrator, OCP-Certified
US Pharmaceuticals IT
Glaxo SmithKline
-Original Message-
From: Kris Austin [SMTP:[EMAIL
We use an externally identified account here to sign on to the database from
cron for DBA related tasks. Since only the dba team knows the oracle Unix
password it works for us well.
-Original Message-
Sent: Tuesday, June 19, 2001 11:38 AM
To: Multiple recipients of list ORACLE-L
Did you remember the Grants and the Insert ??
create table dual /* pl/sql's standard pckg requires dual.
*/
(dummy varchar2(1))/* note, the optimizer knows sys.dual is single row
*/
storage (initial 1)
/
insert into dual values('X')
/
create public synonym dual for dual
More info on this, the error occurs during the export.
The bug was fixed in 8.0.5, says Oracle Support, but because I am using an
Oracle 7.3. export file we get the oversized file errors during the import,
even if we are using the 8.1.7 import utility..
Patrice Boivin
Systems Analyst (Oracle
I can't get this page to come up but I suspect it is an old piece of code
that pads a bunch of spaces so that the password is hidden when a user does
a ps -ef command. Beware, this is not foolproof. There are X-Windows
utilities in almost all incarnations of UNIX that show the complete line, no
Look at OPS$ user accounts in the DOC's.
Yigal
Kimberly Smith [EMAIL PROTECTED] wrote:
We use an externally identified account here to sign on to the database
from
cron for DBA related tasks. Since only the dba team knows the oracle Unix
password it works for us well.
-Original
Here is our method:
1. We save the passwords in a file using the OS level command CRYPT.
2. To run something we call a script file from Cron that first goes and gets
the encrypted password from config file.
3. Then we decrypt the password using CRYPT.
4. Then we start the sql process with the
Look at OPS$ user accounts in the DOC's.
Yigal
Kimberly Smith [EMAIL PROTECTED] wrote:
We use an externally identified account here to sign on to the database
from
cron for DBA related tasks. Since only the dba team knows the oracle Unix
password it works for us well.
-Original
I need to calculate the size of the table assuming one of the rows is
having
all the columns maxsize possible.
I don't understand your question. Do you want to plan in advance to make an
estimate of how large a table will be, or are you looking at an existing
database and wanting to find out
Dual is not a table.
It just a placeholder.
At 11:04 AM 6/19/01 -0800, you wrote:
You could always just run catalog.sql as sys.
-Original Message-
Sent: Tuesday, June 19, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L
Your email says duel. You created dual, with an a, right?
Wrong, DUAL is a table owner by the SYS user that contains one row. Check your
DBA_TABLES and DBA_OBJECTS views.
[EMAIL PROTECTED] 06/19/01 03:56PM
Dual is not a table.
It just a placeholder.
At 11:04 AM 6/19/01 -0800, you wrote:
You could always just run catalog.sql as sys.
-Original
I think Dual is a table.
1 SELECT TABLE_NAME FROM SYS.DBA_TABLES
2* WHERE TABLE_NAME='DUAL'
SQL /
TABLE_NAME
--
DUAL
SQL DESC DUAL
NameNull?Type
---
DUMMY
My feelings are that the list strongly likes AIX as far as getting more bang
for your buck. - E
-Original Message-
Sent: Tuesday, June 19, 2001 11:38 AM
To: Multiple recipients of list ORACLE-L
All,
For a position that would (possibly) like me to set up an
Oracle infrastructure from
alter table tblname move partition partition_name tablespace tbs_name
-Original Message-
Sent: Monday, June 18, 2001 11:17 AM
To: Multiple recipients of list ORACLE-L
Helo all,
How can i move one or more paritions from one tablespace to another.
I checked the objects for TSPITR,
Hi all,
I installed Oracle8.1.6 on a SunOS 5.6 box. That box
already had 815 and 817 installed. When I'm in 816
Oracle_HOME/bin, sqlplus works fine but when I do
svrmgrl which does exist, I got this:
ld.so.1: svrmgrl: fatal: relocation error: file
svrmgrl: symbol kghla42_: referenced symbol
This is a bug. You've probably got an ORA-600 too in your alert log. I had the same
problem and upgraded to 8.1.7.1 to fix it.
Saul Solomon
Senior Database Administrator
PPG Industries
[EMAIL PROTECTED]
412 434-3504
-Original Message-
Sent: Tuesday, June 19, 2001 4:22 PM
To: Multiple
This advise was applicable to those living outside USA and not living
in NEWYORK/CALIFORNIA as they are already well aware of such sites...
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 19 Jun 2001 10:55:59 -0800
That would be good advice
Hi
If i have one file a.txt and I want to put that content in where clause of
sql statement then how can I do it.
Example :
a.txt content
98989
67676
898989
Select x,y,z from abc
where x in (98989,67676,898989)
/
Actuall I want to do it in unix.I want to know the first 2 or 3 high CPU
using
Uh Hal,
You should read the books. Dual is a table.
And whoever suggested to re-run catalog was not quite correct.
Dual is created in the sql.bsq file.
the actual script says:
=== from sql.bsq ===
create table dual /* pl/sql's standard pckg requires dual.
*/
(dummy
I'm trying to a transportable but the export session is hanging.
The v$session says the session is actually active.
Anybody here has any such experience?
Any ideas to resolve this?
Thanks
Kumanan
SQL set autoprint on serveroutput on
SQL exec dbms_tts.transport_set_check ('DATA',TRUE);
1 - 100 of 119 matches
Mail list logo