Hi guys,
Do you have any scripts to display all created users with those roles
granted and the roles information.
currently I am using
table_privileges
role_tab_privs
Thank you,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City N
run pubbld.sql present in $ORACLE_HOME/sqlplus dir under system account in the second
database
--
On Tue, 06 Mar 2001 19:20:21
Bambang Setiawan wrote:
>Wahai Guys,
>
>I created second database using Database Assistant on NT.
>There's no error when I create this 2nd DB.
>Then I make a host-st
Hi Mandar and other Oracle gurus,
As DBA, I don't have the table called "dict_comments" do you guys have any
ideas how to create one and populate with the correct information the
tables? or may be I have to run an oracle's script to get that table ?
-Original Message-
Ghosalkar
Sent: Thu
start by reading the docs on dba_* views.
joe
[EMAIL PROTECTED] wrote:
>
> Hi guys,
>
> I'm new in Oracle8i for Solaris 2.7, I'm not familiar with those data
> dictionary view, do you have any scripts to share such as to display
> redologs, tablespaces, earlier potential problems detection?
>
Don,
Sounds like you've got a good base to run from, especially if you can get
the memory for 3 instances. Now don't forget the other part, lots of Disk IO
capacity. I've a 100GB database on an HP 9000/K570 with 4 250MHZ CPU's (I
believe). The system supports 100+ users and 150 automatic t
select * from dict_comments
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 07, 2001 8:26 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Script for heaven
>
>
> Hi guys,
>
> I'm new in Oracle8i for Solaris 2.7, I'm not famili
Hi guys,
I'm new in Oracle8i for Solaris 2.7, I'm not familiar with those data
dictionary view, do you have any scripts to share such as to display
redologs, tablespaces, earlier potential problems detection?
Thank you so much..
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-
Hi guys,
I'm new in Oracle8i for Solaris 2.7, I'm not familiar with those data
dictionary view, do you have any scripts to share such as to display
redologs, tablespaces, earlier potential problems ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROT
Hi neena
> Hi All ,
> I am in India . I am an OCP DBA (8i)
> having three years IT experience ( Oracle( 7.3, 8 ) and
> Developer2000 , OS -
> windows NT).Three months back I have joined one of the known
> company of India. The role of mine in the present job is
> of DBA
*>thank-god they save 1 billion dollars on using there own software.
ooppss...their
===
Patrick Housholder
Sr. Staff Anl Tech Spt Design
United Airlines Flight Training Center
Denver CO
*>-Original Message-
This is request for the second time; please any one there know anything or can provide
value
rgds,
raja
--
On Tue, 06 Mar 2001 21:15:48
Viraj Luthra wrote:
>Hello every one,
>
>This one is may be a bit off topic but an important topic, for me at least. Is there
>some one out there wh
Hi All ,
I am in India . I am an OCP DBA (8i) having three years IT
experience ( Oracle( 7.3, 8 ) and
Developer2000 , OS -
windows NT).Three months back I have joined one of the known company of India. The
role of mine in the present job is
of DBA. I
have to handle two O
Version of oracle?? I know from personal that 8.1.6 has problems with
snapshot logs not being purged.
-Original Message-
Sent: Wednesday, March 07, 2001 4:17 PM
To: Multiple recipients of list ORACLE-L
refreshed from master?
Hello Forumists,
How to know which are the snapshots supposi
Paul,
Thanks for the heads up. The application in question uses a lot of in-line
views, sometimes nested quite a few levels deep. On 7.3, they encountered
various aliasing problems -- needing to alias the column names in the
in-line views even if the name remained the same as the column name when
Joseph,
Following might help you.
We have databases 8.1.6 on Solaris 2.7. On NT4 we have 8.0.4. We export user
schema/tables from 816 and import the schema/tables into 804 on NT.
Important things are:
If your databases versions are same on both the machines, then use the same
exp/imp software
just move the expdat.dmp using a ftp binary data transfer and and use the
imp utility.
-Mandar
> -Original Message-
> From: Leyden, Joseph [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 07, 2001 4:32 PM
> To: Multiple recipients of list ORACLE-L
> Subject: export/import
>
>
> Can
Title: OT: ODBC version errors
Lisa,
Dont ever use Oracle 8/8i drivers. I had a pretty bad experience
with them.
I was
called at a clients place to check their web app. they were using silk test to
check the load performance against SQL Server 7 and Oracle 8i.
when
connected to SQL S
ha,
thank-god they save 1 billion dollars on using there own software.
p-
===
Patrick Housholder
Sr. Staff Anl Tech Spt Design
United Airlines Flight Training Center
Denver CO
*>-Original Message-
*>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Beh
Hey Sam,
Dont take it so seriously. Ur "Lead Developer" is just testing ur patience.
-Mandar
> -Original Message-
> From: Sam Bootsma [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 07, 2001 2:22 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle Compiler Bug? (+) symbo
Many queries that worked in the past, which were syntactically
challenged, fail with Oracle8. In theory, they never should have
worked. Oracle is just applying the theory more strictly.
Pete Barnett
Oracle Database Administrator
Regence BlueCross BlueShield
[EMAIL PROTECTED]
On Wed, 7 Ma
Title: RE: export/import
> -Original Message-
> From: Leyden, Joseph [mailto:[EMAIL PROTECTED]]
> Sent: mercredi, 7. mars 2001 14:32
>
> Can I import a database from NT which was
> exported from AIX RS6000 servers? Do I just
> move the expdat.dmp (exported output) from
> AIX to NT an
Hi, Alex,
1. Can I ask you, what's UT.222? If UT supposed to be oracle schema, 222 is
not valid index name.
2. You can specify tablespace for EVERY next index partition, if you specify
CREATE INDEX ... TABLESPACE xxx and then move all partitions wherever you
want. After all new partition
Hi
RWAST means Resource Waiting for ASynchronous Trap. They are usually
temporary but if for some reason you have a run away process they can remain
forever. I've seen this happen when a process tries to communicate with
another
that doesn't respond and an intercommunications mailbox fills up. It
Can I import a database from NT which was
exported from AIX RS6000 servers? Do I just
move the expdat.dmp (exported output) from
AIX to NT and simply use the export/import
utilities?
TIA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leyden, Joseph
INET: [EMAIL PR
Title: Off-Topic OAS, IAS, and Apache
I have little experience using web servers for high volume sites. We have one project that expects to have 1,000 concurrent users. They're using OAS and load testing with Load Runner. They're having problems getting anywhere close to that. I don't know
I've certainly never seen the (+) symbol anywhere but in the where clause.
Did you check the results to see if they were the same or different?
Anyway, you shouldn't need it, and I believe you are correct. ;-)
Diana
-Original Message-
Sent: Wednesday, March 07, 2001 3:22 PM
To: Multiple
Alex,
You have the syntax correct, but your index name seems invalid. Also, there
is no need to put double quotes around the tablespace name.
alter index rebuild partition tablespace
is correct, though.
HTH,
Diana
-Original Message-
Sent: Wednesday, March 07, 2001 12:46 PM
To: Mu
Title: OT: ODBC version errors
Lisa
In
general, I disable Dr Watson because it seems to have alot of problems with
Oracle Reports and other packages. Sorry I can't answer your other ODBC
issues as I haven't had any problems with the 8.1 Oracle drivers. I know
we use Intersolv drivers for
Im doing this on a dual 500Mhx Dell box with a Raid5 array now and 1g of
memory.
No issues.
--
Tony JohnsonEmail : [EMAIL PROTECTED]
Senior Database Administrator Vo
Hi!
Thanks a lot..
Can you please give me more details of how
you went about OPS?
Like
a. How u r ensuring fail over in case of
shared disks' failure
b. What r the entries required to handle
Net8 connections' failover seamlessly?
c. Is disk affinity advisable?
If so ho
Title: OT: ODBC version errors
Hi everyone -
I have several developers telling me that their web applications (some are purchased packages and some are developed in-house) do not work with Oracle ODBC drivers if they are version 8. Every one of their applications seems to run fine with th
Hello Forumists,
How to know which are the snapshots supposingly to get
refreshed from the master? In my situation, I have
around 40 databases refreshing from a single master
and seems to be all the 40 databases' snapshots are
getting refreshed. So, why my snapshot still grows
without purging aut
Does anyone have any experience with AIX in an NIS+ environment. In
theory, this is possible. So far, we have not be able to get it to
work. AIX and Oracle 8.1.7 work well with local accounts for Oracle and
the DBAs. Automounting file systems has been successful. However, NIS+
just does n
I've been looking around for ways to determine how much processor speed I
need for a new installation. From what I found so far there are basically
two ways to do this.
1. Spend the time and money on resources and tools to analyze the needs.
2. Make a best guess and go from there.
Given the li
I did an 8.0.something(4 or 5) upgrade to 8.1.6. First I had to
reinstall the OS (well actually the sys. admin. dudes did
that) from 10.20 to 11. They reinstalled instead of upgrade
because it went from 32-bit to 64-bit. Then we put the logical
mounts for the database back in and did the upgr
>From Metalink:
Problem Description:
While querying "user_objects", under the "OBJECT_TYPE" column, you see a value
of "UNDEFINED" on some of the objects. What does this signify?
The "dba_objects" view shows LOB object type as UNDEFINED ;
but "user_objects" view shows it
Title: RE: Dropping datafiles
If this datafile is one of a group of datafiles, that is to say tablespace TS1 has multiple datafiles along with the one created in error, do not offline drop the datafile. Oracle knows of the datafile and offline drop does not remove the information.
Story: A
I am running Oracle 8.1.6 on Windows NT. The query below to create a view
compiles on Oracle 8.1.6.1.0, but not on 8.1.6.3.0. If I remove the (+)
from within the decode statement, it compiles in 8.1.6.3.0. Our lead
developer insists it is valid and he also insists the query gives different
resu
The long can handle two Gig but not much else
can. For example, PL/SQL can handle 32k and the last
numbers I have from Oracle Forms is 56k.
-Original Message-
Sent: Wednesday, March 07, 2001 2:00 AM
To: Multiple recipients of list ORACLE-L
Oracle says data type Long can contain 2G da
You can try importing with a SHOW=Y to check for corruption and to see where
it stops.
Henry
-Original Message-
Sent: Wednesday, March 07, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L
I've also experienced this one time in the past, but there was one added
piece
to the puzzle.
What is the latest guesstimate when Oracle 9 DB server will be released?
--
Charlie Mengler Maintenance Warehouse
[EMAIL PROTECTED] 10641 Scripps Summit Ct
858-831-2229 San Diego, CA 92131
The future is here. It is just not evenly distributed.
Hi gurus
I found that one of objects has status INVALID.
The following are the output.
OWNEROBJECT_NAMEOBJECT_TYPESTATUS
-- -- ---
SCOTTEMP_SNAPUNDEFINED INVALI
I've also experienced this one time in the past, but there was one added piece
to the puzzle. I had ftp'd the dump file from one machine to another and had
done so in ASCII mode by accident. Retransferring the file in BINARY mode fixed
the problem.
Dick Goulet
Reply Separat
Title: RE: NUMBER datatype
> -Original Message-
> From: paquette stephane [mailto:[EMAIL PROTECTED]]
> Sent: mercredi, 7. mars 2001 00:31
> To: Multiple recipients of list ORACLE-L
> Subject: RE: NUMBER datatype
>
>
> Hi Steve,
>
> I posted that question a couple of days ago but got
Title: RE: error after creating second database
> -Original Message-
> From: Bambang Setiawan [mailto:[EMAIL PROTECTED]]
> Sent: mardi, 6. mars 2001 21:55
>
> but my primary question not only how to fix it but
> why this thing happened ?
>
> >>> "Joseph S. Testa" <[EMAIL PROTECTED]>
Hi all,
I just looked at some trace files from today and there is one of the
ugliest things I have seen in a while. Oracle 8.1.6 on NT 4, has anyone ever
seen this or could anyone offer any advice. I was thinking of the good
ol'reboot, but maybe there is a real solution. Here's part of t
I had this happen once. The export seemed to go okay but when I went to
import it everything fell apart. Try doing the export again. When I tried
it again it worked. Oracle support had to reason for it.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECT
Hi, Alex,
1. Can I ask you, what's UT.222? If UT supposed to be oracle schema, 222 is
not valid index name.
2. You can specify tablespace for EVERY next index partition, if you specify
CREATE INDEX ... TABLESPACE xxx and then move all partitions wherever you
want. After all new partition
The disk packs (probably still) come with 60 day trials for everything you
didn't buy.
Alternatively, if you have 10 developers, you could buy a 15-user license for
your developer & test machine (10 devs + you, your assistant, your operator and
a couple spares in case you expand). The software
Title: RE: Off Topic - PKZIP
> -Original Message-
> From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
> Sent: mercredi, 7. mars 2001 07:41
> To: Multiple recipients of list ORACLE-L
> Subject: Off Topic - PKZIP
>
>
> This is off topic but I figured someone on the list would
> know the
Oracle profit warning spells doom:
http://www.zdnet.co.uk/news/2001/8/ns-21312.html
---excerpt---
Lowered spending for software has hit Oracle
where it hurts
Oracle, the world's second largest software
company, on Thursday joined the list of
technology bellwethers warning that a slowing
Something I forgot to mention in the original post...
I am trying to create test databases (one for Oracle 8.1.6 and one for
Oracle 8.1.7). The database creation scripts and the parameter files are
created from templates and thus all parameters are pretty much equivalent
except in places where
Title: RE: Svrmgrl "connect internal" asks for password??
Metalink: 114384.1
-Original Message-
From: Terry Ball [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 1:07 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Svrmgrl "connect internal" asks for password??
Title: RE: Off Topic - PKZIP
> -Original Message-
> From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
> Sent: mercredi, 7. mars 2001 07:41
> To: Multiple recipients of list ORACLE-L
> Subject: Off Topic - PKZIP
>
>
> This is off topic but I figured someone on the list would
> know the
ALTER SYSTEM SET FIXED_DATE = '-MON-DD HH:MI:SS'
Joan
-Original Message-
Baskar
Sent: Wednesday, March 07, 2001 12:06 PM
To: Multiple recipients of list ORACLE-L
Hi,
Could any one tell me how to change the date and time in Oracle Database to
future rather than doing in unix serve
Do you have set it TWO_TASK ?. If the answer is yes, unset it.
Do you have the parameter SQLNET.AUTHENTICATION_SERVICES = in the
sqlnet.ora ?. Remove it.
Regards.
> -Mensaje original-
> De: Raghu Kota [SMTP:[EMAIL PROTECTED]]
> Enviado el: miércoles 7 de marzo de 2001 18:16
> P
Do you have a password file set up for the 8.1.6 database ? Check your
init.ora file to see whether you have specified any password file to store
the internal password (parameter remote_login_passwordfile ..
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
Try looking in $ORACLE_HOME/rdbms/audit directory. If this directory is
full, it can not create the .aud file to log that someone is using svrmgrl and
will
ask for password.
Terry
"Fowler, Kenneth R" wrote:
> List,
>
> I have an installation of Oracle 8.1.6 on a DBA test server where svrmgrl
>
Hi Ken,
I had similar problem once. What I did was I recreated the password file
using orapwd utility for that instance. Irrespective of the password you
specify while using orapwd, it stopped asking for password!! May be this
will work. But be careful with the orapwd utility, not to replace t
That is certainly my understanding.
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
Wednesday, March 07, 2001, 3:31:28 AM, you wrote:
ps> Do you agree that if I create a table with
ps> plain nu
alter TYPE SYS.PQ$_DEQUEUE_HISTORY_T compile;
Terry
mala singh wrote:
> Hi gurus
> I found that one of objects has status INVALID.
> The following are the output.
> OWNER OBJECT_NAME OBJECT_TYP STATUS
> -- -- ---
> SYSPQ$_DEQUEUE_HISTORY_T T
Tuesday, March 06, 2001, 9:05:27 AM, Patrice Boivin wrote:
BPJ> I am just curious - I had major problems with it when they informed me that
BPJ> taking Microsoft courses on NT wasn't good enough, to be certifiable as an
BPJ> Oracle on NT Master you had to have learned NT from... Oracle. Even thou
Check out Info zip at : http://www.info-zip.org/pub/infozip/
It has zip/unzip utils for almost all platforms (including MAC and
Windows).
HTH,
Dave Drienhuizen
give default password "oracle"
>From: "Fowler, Kenneth R" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Svrmgrl "connect internal" asks for password??
>Date: Wed, 07 Mar 2001 09:00:44 -0800
>
>List,
>
>
>I have an install
Hi,
I'm running Oracle 8.0.5 and I have a partitioned table with local indexes.
I try to: put partition data and partitioned indexes in different
tablespaces.
As you probably know Oracle when you create a new table partition creates
implicit local indexes partitions, but you cannot specify to p
I believe tucows as zip tools for the Mac OS, and others. I routinely
get zipped files from windows system and unzip them on my Unix box.
Smith, Ron L. wrote:
> This is off topic but I figured someone on the list would know the answer.
> Is there a way to create a PKZIP file on a MAC machine a
If you're on an appropriate version on Oracle and the file doesn't yet
contain any data you could always resize the file to virtually nothing.
-Original Message-
Christian
Sent: Wednesday, March 07, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L
Clint,
I advise you to read Orac
Hi,
Could any one tell me how to change the date and time in Oracle Database to
future rather than doing in unix server.
Baskar
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ramasamy, Baskar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
List,
I have an installation of Oracle 8.1.6 on a DBA test server where svrmgrl
"connect internal" seems to want a password...
Sun Microsystems Inc. SunOS 5.8 Generic February 2000
Configured oracle environment aliases...
Alias SID Oracle Home
- --- -
Hi man,
during migration you just follow these steps.I didn't read any document.The
migration typically takes 2-3 hours on each database (You have to upgrade your
replication also if it is there).It depends on your machine RAM etc ofcourse
1) run u0800050.sql in $ORACLE_HOME/rdbms/admin direct
*Description:
Oklahoma City, Oklahoma company needs an Oracle DBA experience to join
its' I.T. team.
This position will have typical DBA responsibilities i.e.: physical
database design, installations,performance analysis, system tuning, backup,
recovery, etc.
This is a full time staff position.
Hi!
Have a look at my shareware tool
named OSession. It's small and
easy to use.
Cheers
DO
email: [EMAIL PROTECTED]
web: www.materialdreams.com
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, March 07, 2001 5:41 AM
To: Multiple recipients of list ORACLE-L
Hi guys,
It is possi
This is off topic but I figured someone on the list would know the answer.
Is there a way to create a PKZIP file on a MAC machine and then unzip it on
an NT machine?
Ron Smith
Database Administration
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Auth
On Wed, 7 Mar 2001,Smith, Ron L. scribbled on the wall in glitter crayon:
->This is off topic but I figured someone on the list would know the answer.
->Is there a way to create a PKZIP file on a MAC machine and then unzip it on
->an NT machine?
->
->Ron Smith
->Database Administration
->[EMAIL P
NOO
you will screw up the database that way.
You MUST recreate the tablespace without it. You cannot just offline drop
it.
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE:Dropping datafiles
>D
depends on if you can take away that tablespace for a while.
If you can, and you really truly want to remove the datafile:
export the data from that tablespace (either table by table or by user)
alter that tablespace offline and drop it
recreate the tablespace without that datafile
import the
Hi gurus
I found that one of objects has status INVALID.
The following are the output.
OWNER OBJECT_NAME OBJECT_TYP STATUS
-- -- ---
SYSPQ$_DEQUEUE_HISTORY_T TYPE INVALID
How to correct this object.
Please advice me.
Thanks.
-Mala
_
Read again what C. Trassens wrote -
No, because the datafile will be remaining in the dictionary. The clause
offline or offline drop deletes from the controlfile. Therefore, you will
receive dbwr errors on account that it expects to allocate data in that
datafile. The behaviour is the same even
Hi Cyril, Alex,
Oracle Parallel Server 8.1.6 on IBM AIX 4.3.3 requires
HACMP/ESClustering software, Add on to AIX
SSA Serial Storage Array, IBM's Disk Array
provide shared disk
Hi speed Intercon
Clint,
I advise you to read Oracle Backup & Recovery from Rama Velpuri. One of
McGraw series.
Regards.
> -Mensaje original-
> De: Clinton Naude [SMTP:[EMAIL PROTECTED]]
> Enviado el: miércoles 7 de marzo de 2001 13:36
> Para: Multiple recipients of list ORACLE-L
> Asunto: RE:
- Original Message -
To: "tax announce" <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 9:08 AM
> ***
> THIS IS VERY IMPORTANT!!!
> ***
>
> I received a virus alert from our anti-virus software provider this
morning
> c
No, because on that way you only drop from the controlfiles and not from the
dictionary. PLEASE READ THE LAST MAIL I SENT ABOUT IT.
Regards.
> -Mensaje original-
> De: Clinton Naude [SMTP:[EMAIL PROTECTED]]
> Enviado el: miércoles 7 de marzo de 2001 13:31
> Para: Multiple recipients
We want to do an 8.0.5 to 8i upgrade (HPUX). There are six databases
on the system where the upgrade is required. How long does the
upgrade typically take? What kind of downtime should be expected?
Are there any major "gotchas" of doing the 8.0.5 to 8i upgrade?
-
Sent using MailStart.com
Procedure builder is going away you'll have to use stored procedure
editor from within forms builder.
HTH
Raj
*
This e-mail message is confidential, intended only for the named recipient(s) above
and may contain informati
List hi!
>From one schema in production database I want to create same indexes on the
other (same schema on different instance).
I know that I can do it with imp in indexfile, but it is not good enough.
Does anyone have script with which I could dinamicaly create indexes on all
tables within sch
This is my understanding as I am studying for my Certificate at the moment.
At the end I will be an OCP but a DBA type of OCP .
Martin
-Original Message-
Sent: 07 March 2001 12:51
To: Multiple recipients of list ORACLE-L
This is funny, because last year they were tagging "Masters"
This is funny, because last year they were tagging "Masters" courses at the
end of the OCP training path - you earned your OCP, and only then could you
take Masters courses.
They had at least twenty, including Internet DBA courses, Internet
Applications DBA courses, Master DBA on Solaris, on NT,
A 12154 is TNS could not resolve service name. This means that you have
either entered the wrong connect description, or you do not have the right
entry in your tnsnames.ora file. Now I am a little confused with this, as
you HAVE managed to connect to shut the database down, but can no longer
conn
Quite correct, offline drop is archive log mode, using just drop is non
archive log mode.
Clint
* E-mail: [EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, March 07, 2001 2:06 PM
To: Multiple recipients of list ORACLE-L
alter database offline drop;
I think you need to hav
Of course there is.
Alter database datafile '" offline drop.
* Clinton S. Naudé
* Head systems administration
* Tel: 011 685 4304
* Fax: 011 685 4303
* Cell: 082 377 1726
* E-mail: [EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, March 07, 20
No, because the datafile will be remaining in the dictionary. The clause
offline or offline drop deletes from the controlfile. Therefore, you will
receive dbwr errors on account that it expects to allocate data in that
datafile. The behaviour is the same even if you use locally management
tablespa
No. The problem is that Oracle 8i standard doesn't support bitmap. You must
purchase the 8i Enterprise Edition, if you need bitmaps. Refer to 70059.1 in
Metalink.
Regards.
> -Mensaje original-
> De: Leslie Lu [SMTP:[EMAIL PROTECTED]]
> Enviado el: miércoles 7 de marzo de 2001 3:06
Saurabh
You r right.I meant that only.you have to supply whole string after &,If you
unwilling to change define parameter
Thanks
Ganti
---
The contents of this e-mail are confidential to the ordinary user
of the e-mail address
alter database 'datafile' offline drop
and then recreate the datafile in some othe tablespace
Cheers
Ganti
---
The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and
alter database offline drop;
I think you need to have the database in NOARCHIVELOG mode to do this
though. Also, I'm pretty sure that you will not be able to reuse the
datafile name, as it will still be stored within the bowels of Oracle.
The list can confirm if I am wrong though :)
HTH
Mark
Friend :
If you are using sql plus type :
set define off
It will solve the problem.
Eriovaldo do Carmo Andrietta
[EMAIL PROTECTED]
Limeira/SP - Brasil
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 6:40 AM
> WHen i
NO way. At least you could resize it smaller.
Regards.
> -Mensaje original-
> De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Enviado el: miércoles 7 de marzo de 2001 12:05
> Para: Multiple recipients of list ORACLE-L
> Asunto: Dropping datafiles
>
>
>
> Ouch, big mistake :
Dear Mr. Robert,
Hi! Do you have the ILT Study material for any of the masters' modules?
If so, can you lend it to me? By the way, in which countries is the masters
certification program conducted? Please reply.
Thanks and Regards,
Ranganath
-Original Message-
Robert D SSgt
No, you don't need OEM to use RMAN. You just type 'rman' from your command
prompt. The following URL should help :
http://www.oracle.com/oramag/oracle/00-Mar/index.html?o20rec.html
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, March 07, 2001 9:46 AM
To: Multiple recipients of l
I feel u can't insert in this way. this way it will only insert value given
by u when it prompts.
if u give & then it will insert that only, else if u had to give the entire
value after the & sign in the original value.
i think the best way is to change the default define character with one not
1 - 100 of 111 matches
Mail list logo
