Dear list,
we have a 8.1.7 running on NT4. A NT-service copies flatfiles from a VAX/VMS
and starts a batch, which imports the data into the DB. VMS is reached via
Pathworks. Now, when Pathworks is installed an the machine running the
instance, the instance seems to become instable and dies under
Title: RE: HELP : doubts regarding --- Tablespace ,Roll Segment , diff between oracle 8i and 9i, and between oracle 8i and previous versions - urgent
Hi sangeetha,
Well, hope that u want to know all in big things in one struch ;-).
Ok, here are my answers to you.
1) If the tablespace
hi,
thanx a lot...rao,mark and don.u're info has
clarified my doubts.
sangeetha
__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
--
Please see the official ORACLE-L
Yea, but he didn't specify Oracle version.
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 11/27/2001 5:55 PM
Actually, you can. Use FGAC (Fine-Grained Access Control) and you can
put a
Policy in place on a table that even the table owner can't bypass - even
System c
Like I said, an HR problem.
Or a training problem.
:-)
With Treacly Love, and Unctuous Peace,
etc.
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 11/27/2001 5:45 PM
But of course a delete trigger is not called on a truncate...
Ron Thomas
Hypercom, Inc
[EMAIL
Hi lists,
Is there a script/command to analyze only the latest partition of my
table. It has several partitions. For every month 1(one) partititon gets
created to store that months data.
Can anybody throw some script.?
Thnx and Regards,
Srinivas
--
Please see the official ORACLE-L FAQ: http:/
Hi
What could be impact if objects are having status INVALID?
Thanks
Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seem
1) Users are created in the database, not in a particular tablespace.
If a tablespace is dropped dwith the "including contents" clause, then
objects in the tablespace are also dropped. Dropping a tablespace
NEVER drops users.
2) The function of rollback segments is described in the concepts
manu
Chevy's was good, we will need a reservation -- and it's loud
but everything will be loud
--- John Kanagaraj <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I don't know the SF restaurants well enough, but Chevy's seems good
> enough.
> Howard and 3rd is close enough to Moscone.
>
> I will also be
not too loud? good luck Jeremiah :)
I'll be there, someone just tell me where there is
There's a Jillian's across from the Moscone, but that will be loud.
--- Jeremiah Wilton <[EMAIL PROTECTED]> wrote:
> To continue the discussion on getting together at Openworld:
>
> How about Tuesday evenin
Run sqlldr from the OS command line, not from SQL*Plus.
-Don Granaman
[OraSaurus]
- Original Message -
To: "Oracle DBA List (E-mail)" <[EMAIL PROTECTED]>; "Oracle
SQL*Loader E-Mail List (E-mail)" <[EMAIL PROTECTED]>; "Oracle-L
(E-mail)" <[EMAIL PROTECTED]>
Sent: Tuesday, November 27, 200
Good to know that it really works, although I kind of have lost hope in my
case here using 8.0.5. Maybe it is 8.0.5. I dunno. But thanks for the
input anyway.
George
-Original Message-
Sent: Tuesday, November 27, 2001 4:07 PM
To: Multiple recipients of list ORACLE-L
George,
I've ju
uh u meant somin like tuning discussion is beyond the
scope of this paper ;)
--- Connor McDonald <[EMAIL PROTECTED]> wrote:
> You just open up with:
>
> "This is statspack. You install it with spcreate,
> collect stats with a pl/sql call, and report with
> spreport.sql. Then you interpret the
i.e. unless u dont have a truncate trigger instead ..
lol
Create or Replace Trigger StopTruncatesAndDrops
Before TRUNCATE or DROP on database
WHEN (ora_dict_obj_name = 'MTRX_GAME_SESSION_FACTS'
AND ora_dict_obj_type = 'TABLE')
declare
begin
raise_application_error(-20211, 'Cannot Drop or
George,
I've just tried the process as you've listed below (including dropping the exported
table before importing again) and it worked fine without needing to precreate the
table in the new tablespace. This is on Oracle 8.1.7. I noticed that the DDL in the
export file included the old table
I know this. But I just wanted to avoid the hassle of precreating the
tables, creating the views and other objects. Note:1012307.6 in Metalink
seems to encourage that approach.
George
-Original Message-
Sent: Tuesday, November 27, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L
> --
> From: Baker, Barbara
> Sent: Tuesday, November 27, 2001 4:42 PM
> To: '[EMAIL PROTECTED]'
> Subject: FW: unzip utility information
>
> You might have a pathing problem (i.e., unzip is there, but you have to
> specify the full directory path to execute it.)
Funny because Oracle has explicitly stated that you can actually import a
user's objects to it's new default tablespace as long as you make sure that
the user doesn't have any quota or privs on the old tablespace.
George
-Original Message-
Sent: Tuesday, November 27, 2001 1:00 PM
To: Mul
Paul,
Here's a place to start. The first link on this page is John Kirch's
famous
Unix vs. NT arcticle.
http://people.freebsd.org/~andreas/unix-vs-nt/
By the by, has management made a business case for moving it to NT?
If you have access to Gartner, they may have something helpful.
Most I
George,
If import sees the old tablespace (the tablespace where the table was exported
from), it will try to import the table into it, even if the user has no quota
(of course then you abend with a quota error). Our workaround is to pre-create
the table in the new tablespace. Then you have to i
Ken,
Sqlldr is a stanalone utility, it doesn't run from inside SQL*Plus, it runs
from the
OS command line.
Take a look at the utilities manual for the docs on sqlldr.
Jared
Hi all,
I don't know the SF restaurants well enough, but Chevy's seems good enough.
Howard and 3rd is close enough to Moscone.
I will also be attending only the vendor exhibits, but will certainly meet
the listers if all agree to this location/date/time. (I am hoping y'all
will!!)
John Kanagara
Actually, you can. Use FGAC (Fine-Grained Access Control) and you can put a
Policy in place on a table that even the table owner can't bypass - even
System can't bypass. Only Sys can bypass FGAC policies - and the owner of
the security schema in which you place the Policy functions.
I've used F
Hi Ken,
SQlldr is not a sqlplus command. It will need to be run from the OS
like sqlplus.
Good Luck
[EMAIL PROTECTED] wrote:
>I am in sql*plus (8.1.7) logged in as sys. When I try running "sqlldr" at
>the command prompt I get this error:
>
>SP2-0042: unknown command "sqlldr" - rest of line
At 02:10 PM 11/27/2001 -0800, you wrote:
>hi
>friends if anyone knows about the unzip command in solaris 2.6/2.7
not sure about 2.6 but in 2.7 just:
unzip filename
> .please mail me.ex.OEM204_1.zip file.and i am not getting unzip
> command by using man pages.can i needed to down load any
Sounds like some inverted thinking by management... justify not making the
change(?). Usually you would have a cost-based analysis for making the
change. I've never seen one that would justify NT (I'd love to see it if
they have one). Both Solaris and Linux are alternatives to the OS-specific
har
But of course a delete trigger is not called on a truncate...
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
MohanR@STARS-
Thanks for all your input - I'll be following up on this tomorrow morning,
and will let you all know..
Cheers
Mark
-Original Message-
Sent: 27 November 2001 20:45
To: Multiple recipients of list ORACLE-L
Also check for a delete trigger on the table.
Ron Thomas
Hypercom, Inc
[EMAIL P
I am in sql*plus (8.1.7) logged in as sys. When I try running "sqlldr" at
the command prompt I get this error:
SP2-0042: unknown command "sqlldr" - rest of line ignored.
I'm calling it from my client PC and the DB is located on a separate server.
How do I get this to work?
--
Please see the
You just open up with:
"This is statspack. You install it with spcreate,
collect stats with a pl/sql call, and report with
spreport.sql. Then you interpret the myriad the
results - but of course, that is a tuning discussion
not a statspack one...Questions anyone?"
:-)
--- Rachel Carmichael <
All the objects are dropped beforehand. The import is done on a clean
slate. I just put in the ignore=y because that's what the docs suggested
and I was half hoping it'll drive the "space quota exceeded..." error away
:)
George
-Original Message-
Sent: Tuesday, November 27, 2001 12:30
hi
friends if anyone knows about the unzip command in solaris 2.6/2.7 .please mail
me.ex.OEM204_1.zip file.and i am not getting unzip command by using man pages.can i
needed to down load any unzip file.
pl. mail command as early
thanking to all
--
Please see the official ORACLE-L FAQ:
Title: RE: Checking DB Status in NT env.
Yea. Connect to the database. If you can connect quickly, you can be sure that most everything is OK.
Lisa Koivu
Oracle Database Monkey Mama with the Big Wide Booty.
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: mitche
hey lisa
Thats what i was temted to reply as well {lol} .. but
if you look closely .. both her conn are bequeth .. i
was under the impression that bequeth was used only
for local and not remote .. thats why we chose beq
over tcp for db's that resided in same box for
performance reasons .. or so i
sqlldr is not a sqlplus command - it needs to be called
from the OS command line.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, November 27, 2001 5:00 PM
> I am in sql*plus (8.1.7) logged in as sys. When I try running "sqlldr" at
> t
>> Where can I get a copy of
>> " Scaling Oracle 8i" please
It's a book.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
set what, precisely, through a trigger?
Geez, if you have a DBA and/or a schema owner that can't/shouldn't be
deleting from a table, what you have is NOT a database problem, it's
an HR problem.
sheesh.
yea, how about this? an "BEFORE DELETE" trigger on the table, saving and
repopulating each
The default tablespace is only used whenever there is no tablesapce
parameter in the crate and alter table/index statements. Since the export
always have tablespace parameter with the create table/index statement, your
import method definitely will fail. You can change the tablespace for the
segme
Title: RE: Delete slowing..
Mark, how many indexes are on the table? Are there any unindexed foreign keys?
Lisa Koivu
Oracle Database Monkey Mama.
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Mark Leith [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27,
Title: svrmgrl and W2k
Lisa,
I'm
running 8.1.6 and 8.1.7 EE on Win2k machines and I connect to them all the time
via Terminal Server. I get the same ORA-12560, but I just invoke svrmgrl
using internal@test or internal@dev. Works just fine. Am I
missing part of the problem?
Jack
--
You can't revoke the ability to delete from the schema owner. You
could revoke CREATE SESSION from the schema owner, but that doesn't
solve the problem of DBA-privileged accounts being able to delete.
I'm guessing that this is a perfect opportunity to use an "INSTEAD OF"
trigger.
--- Aldi Barc
Title: RE: SVRMGRL and W2K
Thanks David!!
Lisa
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 12:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: SVRMGRL and W2K
Lisa,
Got bit by this first time ou
Paul - then I would check for a paper from a Unix vendor that discusses
total cost of ownership. A good place to start might be the Sun Web site
since Sun is the major Unix vendor that doesn't offer NT systems. Start
looking at the cost of downtime for your organization. Then there is the
cost of
Listers,
Does anyone have a script that will do the following:
Accept
user input for old data value
Accept
user input for new data value
Disable
table constraint
Update
record with new data value
Enable
constraint
A script like this would help ens
additionally .. -1 means means that the wait is less
than tha 10ms cycle .. i.e. too small to be recorded
and -2 means that timed statistics is off..
--- "Farnsworth, Dave"
<[EMAIL PROTECTED]> wrote:
> Charlie,
>
> WAIT_TIME is measured in seconds. But in order for
> this to be so, you must
>
If they're currently a unix shop and want to save money, why not suggest
Linux? It will run on the same hardware as Windows, and they can
leverage their existing unix experience.
Dennis
Paul Vallee wrote:
>
> Actually, Dennis, it's currently a UNIX shop considering saving money by
> migratin
Paul,
I think Dennis makes a great point here. If your organization thinks that
they can save money by switching hardware, you should point out that all of
the Unix admins will need NT Admin classes as part of the migration to the
new environment.
As I've said in the past, a well-maintained pro
Chevy's at Howard and 3rd is a good spot. I'll probably be attending only
the vendor exhibits but I'll try to make the list get-together.
Gerardo
-Original Message-
Sent: Tuesday, November 27, 2001 11:45 AM
To: Multiple recipients of list ORACLE-L
To continue the discussion on getting
I thought that, given
disks with 256KB to 4M of ondisk cache
and
disk arrays with another 1M-16M of cache
and
storage boxes like EMC,Hitachi, etc with up to 16 GB of CACHE
and
the UBC
and
the Oracle BC
and
Henry Poras' recent post
that
"tables and indexes" in the same tspace didn't matter quite
Title: RE: Connection question?
One is LOCAL=YES and one is LOCAL=NO
One is Local, one isn't.
Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 1:05 PM
To:
The idea is wonderful and also very old. It was one of the first enhancement requests
submitted. As far as I can tell Oracle has never shown an interest in it. Indeed it
appears to be going the other way. Take LOB's for instance. You can place the LOB
segment in a separate tablespace from
Also check for a delete trigger on the table.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Hi Listers,
How can we revoke 'delete privilege' from the schema owner of the table and
also from DBA ?
If it is not possible, can we set through trigger ?
Thanks.
Aldi
_
Get your FREE download of MSN Explorer at http://explorer.m
George Hofilena wrote:
>
> Guys,
>
> I'd appreciate any help that I could get.
>
> I was trying to import to another tablespace, same user. I hadn't had a
> need to do this in a while but thought this shouldn't be too difficult. So
> I did what the manuals said:
>
> ran a user export
Title: Terminal Server / svrmgrl
ZP? As in Zip It?
Just really really frustrating.
Thanks Ross and Michael
Lisa
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L
Subject:
Paul,
If they want to save $$$ they could consider migrating to LINUX. For a
UNIX shop it is a more logical migration than NT/2000. Or, is their
idea to get rid of higher priced SA's in favor of NT
Admins which they think they should pay less? In which case the outcome
is decided all ready.
Ro
Hi
Is there any easy way for our operator to check db status on NT env. any
clue?
Mitchell
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mitchell
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
Mark Leith wrote:
>
> Hi list people :)
>
> We have a customer who has been running a particular delete statement
> against a table for a while now, which usually ran within minutes. All of a
> sudden this table has suddenly gone from a few minutes right up to 50! He
> wants to diagnose why..
>
Eric, are you going?
-Original Message-
Sent: Tuesday, November 27, 2001 2:45 PM
To: Multiple recipients of list ORACLE-L
To continue the discussion on getting together at Openworld:
How about Tuesday evening, around 7:00?
Someone who knows downtown SF want to suggest a place? My pre
Cheersit's a good one.
The Art is on order...showed up..and it's about 90$i am
hoping to get my company to buy it, but that's probably a joke.
I should go in, browse, gulp, and buy it.
It looks just fabulous.
-Original Message-
Sent: Tuesday, November 27, 2001 12:40 PM
T
Actually, Dennis, it's currently a UNIX shop considering saving money by
migrating to NT. It seems like your argument would support sticking with
what they currently have.
Thanks,
Paul
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, Novemb
Paul - What is the base of experience in this shop? Is it primarily an NT
shop and the Unix system is the odd one, or is it primarily a Unix shop and
the NT conversion would be a first plunge? Everything I hear depends
primarily on this factor. Most indications are that the Unix systems tend to
be
Title: RE: Connection question?
1. User connect to Oracle through Unix (for example telnet and then SQLPlus from Unix).
2. Client user.
HTH,
Rivaldi
-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 12:05 PM
To: Multiple recipients of
To continue the discussion on getting together at Openworld:
How about Tuesday evening, around 7:00?
Someone who knows downtown SF want to suggest a place? My preference
is not too loud or too smoky.
Call out on the list if you are going to come, so we can keep track of
how many chairs to stea
Guys,
I'd appreciate any help that I could get.
I was trying to import to another tablespace, same user. I hadn't had a
need to do this in a while but thought this shouldn't be too difficult. So
I did what the manuals said:
ran a user export
set user's quota on old tablespace
Mark,
check for foreign key/missing index combinations. If the table is a parent
table, and it's child's foreign key's column is not indexed, the delete can
take *forever* if the child is a large table.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, Nov
I have tried to run catalog.sql from the sql*plus command line and keep
getting this error.
sp2-0310 unable to open file "catalog.sql". I've use the full path name
with the same results.
catalog.sql is on my PC and the database is located on a server.
I have run other commands from my client
Hi
If one of the tablespace in database is TRANSPORT TABLESPACE.I have full
export with consistent=y and full=y.
Can I full import the database?
If yes then what will happened with transport tablespace?
In case of crash can I restore full database with full export?
The assumption is we don't have
Hi list people :)
We have a customer who has been running a particular delete statement
against a table for a while now, which usually ran within minutes. All of a
sudden this table has suddenly gone from a few minutes right up to 50! He
wants to diagnose why..
Where would you start?
I have a f
Hi
WHen I execute ps -ef |grep LOCAL on Solaris server the following output i
see in
1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
What is the diffrence between 1 and 2.
Thanks
Seema
___
Mark Leith wrote:
>
> Just a question off the wall here - kind of related:
>
> Does anybody know why Oracle does NOT give the option to have a DEFAULT
> INDEX TABLESPACE along with TEMPORARY and DEFAULT (for Tables for example)..
> I know, I know it's just another thing to add to your syntax - b
Hello everyone,
I'm certain that this is a FAQ, but I thought I would make a request here.
I have a client whose management is requesting us to make a business case
for keeping our Oracle on UNIX rather than on NT.
I wonder if anyone can link to or provide any of the following on this
subject:
Sorry for the delayed thanks... but things got hecked here.. Thank you
Michael Vergara and Brian...
On Fri, 9 Nov 2001, Brian McGraw wrote:
> Funny, I wrote a perl script to do this same thing the other day. It is a
> perl script, runs under UNIX, and not only checks for defaults, but the
Thanks Ross. By the way, did you ever get "The Art of Computer Systems
Performance Analysis"?
Henry
-Original Message-
Sent: Tuesday, November 27, 2001 11:25 AM
To: Multiple recipients of list ORACLE-L
http://www.amazon.com/exec/obidos/ASIN/0070388687/qid=1006878161/sr=1-2/ref=
sr_1_14
Wonderful idea, Mark. We have scores of users who create their own tables,
indexes etc since we are a scientific research institution. It's hard to get
users to put in that extra code to place the index in it's own tablespace.
Shirley
-Original Message-
From: Mark Leith
On Tue, 27 Nov 2001,Mohan, Ross scribbled on the wall in glitter crayon:
->with gas?
nope, gas costs extra.;-)
->
->-Original Message-
->From: Thater, William [mailto:[EMAIL PROTECTED]]
->
->
->
->guess i'm just a big mean green DBA.;-)
--
Bill "Shrek" Thater ORACLE DBA
Te
On Tue, 27 Nov 2001,Mohan, Ross scribbled on the wall in glitter crayon:
->
->"What will you be wearing?"
->
->a "short" presentation?
->
->h.
->
->I think I detect a level III Shrek alert
nope, working for a bankrupt company means i don't get to go nowhere or learn
nothing.
guess i'm j
with gas?
-Original Message-
guess i'm just a big mean green DBA.;-)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Ross
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
Lisa,
Got bit by this first time out of the box with W2K. I don't have access to
PCAnywhere, so I had to do the install from the console. I have however
created a ton of .bat files that perform various functions that I can
execute from Terminal Services. I found it necessary to use sqlplus wi
ControlIT (formally Remotely Possible) also works, regardless
of the fact its a CA product.
-Original Message-
Sent: Tuesday, November 27, 2001 8:25 AM
To: Multiple recipients of list ORACLE-L
Yes, I've seen it. Oracle Installation, sqlplus, svrmgrl through Terminal
Server Client do not
Charlie,
WAIT_TIME is measured in seconds. But in order for this to be so, you must
have the TIMED_STATISTICS parameter set to TRUE.
Dave
-Original Message-
Sent: Tuesday, November 27, 2001 9:20 AM
To: Multiple recipients of list ORACLE-L
One of the fields is WAIT_TIME
A non-zero
seconds.
see page 32 of Gaja's Oracle Performance Tuning 101
"The value of this column is STATE dependent and is measured in
seconds"
> --
> From: Charlie Mengler[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Tuesday, November 27, 2001 8:20 AM
Just a question off the wall here - kind of related:
Does anybody know why Oracle does NOT give the option to have a DEFAULT
INDEX TABLESPACE along with TEMPORARY and DEFAULT (for Tables for example)..
I know, I know it's just another thing to add to your syntax - but it would
be a FAR better way
"What will you be wearing?"
a "short" presentation?
h.
I think I detect a level III Shrek alert
-Original Message-
This is a cross-dressing post folks...
so...unfortunately, Susan McClain will not be able to attend OOW, and
it now seems I AM presenting (where the heck did
ok, as much as i think MS could use a major kick in the fundament,
if you think of "terminal server client" as "rsh client" (please no
niggling
corrections of the rough analogy!:-) then you'll not be so vexed at
the lack of functionality.
Sad that this doesn't work, true, but..maybe in XP
http://www.amazon.com/exec/obidos/ASIN/0070388687/qid=1006878161/sr=1-2/ref=
sr_1_14_2/002-3320998-2702448
-Original Message-
Sent: Tuesday, November 27, 2001 10:33 AM
To: '[EMAIL PROTECTED]'
Henry, this is a great post. All I can add of peripheral
interest is a pointer to a book called
Dennis:
Thanks for the advice. Fortunately I am doing a DB conversion from IMS /
Lotus Notes to 8.1.7. This is being done on a dedicated server which only I
have access to and there is no application software connected to it. When I
finish the data conversion the data will be exported (for wan
Yeah, Iain, you are right, and I don't hate to recognize.
Iulian
-Original Message-
Sent: Tuesday, November 27, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L
I hate to disagree but why couldn't you
update x
set field = (select field1
from p
where p.jo
>maybe even moving the largest tables to their own
>tablespace first.
Just remember that if you move a table, all its indexes will be invalid, so
you may want to rebuild the indexes for each table right after the table is
moved.
If you just move the indexes, only the index being moved is temp
sangeetha,
1. When a tablespace is deleted, the users do not get dropped. Users would
still be present. However, the tables created on the tablespace would be
dropped. Users and their details are maintained in Oracle dictionary. If
you have DBA permissions on your database, check the view, db
no way that I know of, you need to move each index on its own
--- Ken Janusz <[EMAIL PROTECTED]> wrote:
> I have this large DB (approx. 250 tables) that has the tables and
> indexes in
> the same tablespace (not my design). Is there a way I can move all
> of the
> indexes to a separate tablespa
Yes, I've seen it. Oracle Installation, sqlplus, svrmgrl through Terminal Server
Client do not work. I used PC Anywhere, everything went fine.
HTH,
Michael
>From: Koivu, Lisa <[EMAIL PROTECTED]>
>Subject: svrmgrl and W2k
>Date: 27 Nov 01, 03:25 PM
>To: Multiple recipients of list O
You can't do it en-mass. Why not write a script to do this.
select 'alter index '||index_name||' rebuild ;'
from user_indexes;
or somthing similar.
Terry
-Original Message-
Sent: Tuesday, November 27, 2001 8:25 AM
To: Multiple recipients of list ORACLE-L
I have this la
One of the fields is WAIT_TIME
A non-zero value is the session's last wait time.
A zero value means the session is currently waiting
What are the units associated with this number?
--
Charlie Mengler Maintenance Warehouse
[EMAIL PROTECTED]
I've never heard of a "mass move index" utility. What I did in a similar
situation is script it, with something like this:
SET head OFF feed ON echo OFF verify OFF pagesize 0 linesize 65 trimspool on
--
spool ind_fix.sql
--
select 'alter index '||index_name||' rebuild '
||CHR(10)||' tablespace
Ken,
Try executing the following:
select 'I am rebuilding my index '||index_name||' and putting it in
another tablespace;'
from user_indexes
/
and of course, spool the sucker, set heading off, set pagesize.
"Merry Spooling and Happy Selecting"
>>> [EMAIL PROTECTED] 11/27/01 08:25AM >>>
I hav
Ken - No, there isn't a magic single command. Moving the indexes, even with
alter index, cause a lot of work for Oracle, and can consume quite a bit of
time. As the typical cautious production DBA, I do not like to start a
really large monolithic process that might make my system unavailable to th
This is a cross post folks...
so...unfortunately, Susan McClain will not be able to attend OOW, and
it now seems I AM presenting (where the heck did I put that skirt?)...
I will be giving her presentation for her Statspack on Monday (I think
at 11)
Be kind folks, I haven't even SEEN the paper or
Ken
set head off
spool c:\index.sql
select 'alter index '|| index_name ||' rebuild tablespace index'
from user_indexes
this would create the script file to rebuild the index
This is the output
alter index S_INVENTORY_PRODID_WARID_PK rebuild tablespace index
alter index S_ITEM_ORDID_ITEMID
sangeetha,
1) If a tablespace is deleted all of the tables, indexes or rollback
segments that reside in that tablespace will also be deleted. Users are not
stored in a tablespace, except in the SYSTEM tablespace - which you DON'T
want to delete as it is the tablespace that runs the Oracle system.
1 - 100 of 128 matches
Mail list logo