 | | | Oracle List | | Hi
While alterering the table to deallocate the extents which are above the
HWM we did use the following command.
alter table <tab > deallocate unused
Another DBA here feels that appending theHi Jonathan
The instance does not need to be running in order to do a CREATE PFILE FROM
SPFILE.
I just tested it on version 9.2.0.
Regards
Jesper Norrevang
-----Oprindelig meddelelse---Version and platform?
On Thu 2004-02-19 at 03 50 Stefan Jahnke wrote
> Hi list
>
> I was wondering what the h%?&ck the HTTP_PROXY environment variable > has to
> with sql*plus?
> After I seAs well as the possible typo do you really want to trace *all* activity on the db including pmon etc? A more usual implementation might be a log on trigger or use of one of the built in packages thaNot to hurt the list owner (Jared) .
I am (as many are ) always thankful to him
for maintaining this wonderful list .
I use Outlook 2002 (10.2627.2625) .
I also see characters like " " "? " onlJared.Still@(protected) scribbled on the wall in glitter crayon
> Well when you finally figure it out if someone will kindly write up
> a concise
> paragraph on the problem and solution I wiIf you can or cannot go to Hotsos the Charlotte Oracle Users Group has an excellent seminar by Jonathan Lewis in MARCH for you..
Check out more details on our website at www.cltoug.org.
RegaPeter
I think more information is needed to make any suggestion.
For instance you are limited by a 1m WAN link.
What 's not mentioned is the time frame for the move.
Is this a production Hi Elain
Check this out I 've used it successfully in the past
http //www.adpc.purdue.edu/DataMgmt/DBA/Stds/sqlscripts.htm
Lisa Koivu
Oracle Monkey
Orlando FL USA
-----Original MessageWhat is so great?
On 02/19/2004 01 23 09 PM "Goulet Dick " wrote
> Bingo!!
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -----Original Message-----
> From JacThis email appears fine here via Lotus Notes.
Jared
"Jacques Kilchoer " <Jacques.Kilchoer@(protected) >
Sent by oracle-l-bounce@(protected)
02/18/2004 03 39 PM
Please respond to oracle
On 02/18/2004 08 21 22 PM Jonathan Gennick wrote
> In my case I couldn 't start my instance at all so I
> wouldn 't have been able to issue the create pfile command in
> step 2.
Jonathan > -----Original Message-----
> Niall Litchfield
>
> So it looks like you got the outlook error sorted. Any chance
> of sharing ei > ther privately or on the list?
I don 't know if it 's really what OS is it on have you followed the install guide and set all the parameters you need to?
What errors do you get?
"alter table move nocompress " certainly seems to be the
obvious option but you will have to do each
partition separately.
You may also have to drop the bitmap indexes
before you move and rebHello.
I 'm hoping someone has a solution or I can talk to someone offline
about this. We take RMAN backups of our production site and standby
site. I want to be able to use the standby backup toThe best thing that I 've ever seen to scan the export file is DBATool
by DataBee. It also works under influence (wine). I haven 't tested it
against 10g that is planned for the incoming Saturday.
hi all
Has anyone migrated a standby database from 8.1.7 to 9.2.0??
If yes could you please outline what were the steps??
I am trying to migrate by applying archive logs from the primary
databaseOn Wed 2004-02-18 at 12 52 Daniel Fink wrote
> In that case #3 would be my choice. Using the indexfile is acceptable but
> it can be hard to read and edit at times. #3 also has the added benefiI am trying to use rman for my data warehouse which is in no archive mode.
I only have room for 1 backup and need to remove last weeks backup prior to
doing this weeks backup.
I set the retentionHi
I have just installed oracle client 9.2.0.1.0 on one unix box (called
curly) and I am trying to connect to an oracle 8173 server (on another unix
box called rex). During the installastion Hi All
I 'm lead editor of the databases group at Apress and Jared has kindly
given me permission for a slightly off-topic post regarding an
opportunity to contribute to one of the books that Hi
I haven 't done Gentoo yet but I installed 10g under Fedora Core 1
with no problems. I know it 's a shirt-tail cousin of RedHat but
not on the "supported " list either.
I am going to instahost C \PROGRA~1\RESOUR~1\sleep.exe 30
----- Original Message -----
From "Smith Ron L. " <rlsmith@(protected) >
To <oracle-l@(protected) >
Sent Wednesday February 18 2004 21 08
Subject ExecWhy put it in a seperate ORACLE_HOME?
----
Matt Adams - GE Appliances - matt.adams@(protected)
In a world without fences who needs Gates?
- JavaOne 1997 t-shirt
-----Original Message---QTParted is what you are looking for.
On 02/18/2004 10 34 53 AM "Boyle Christopher J. " wrote
> Can anyone recommend a good disk-partitioning tool so I can make room
> > for a linux (RH 9) instI don 't installed it in Linux but what I had seen checking at the
support matrix Suse and redhat advanced server are the linux releases better
tested for Oracle.
For example at http //otn.oracleThis thing just popped up yesterday. I 'm using Oracle 9i Rel 2 Ver. 9.2.0.4 on Windows 2000 Advanced Server
This code has been running inside a package for some time and I 've never seen a failure.what do you think both of them the script and the init ora are for 9i
standard edition
DB_BLOCK_SIZE 8192
COMPATIBLE 9.2.0.1.0
DB_NAME XXX
-- IMPORTANTE IMPORTANTE
-- en tnsnames conexi?n debe estar configurada como dedicada ver formulario
instalacion oracle 9i
-- fin importante
SET ECHO ON
connect SYS/change_on_install@(protected) as SYSD |
|
|
