Hi gurus,
I just installed Oracle 8.1.6 on Windows XP successfully. However on creation
of database using the Database Configuration Assistant, I get the error
ORA-12638 'Credential Retrieval Failed' on initialisation of database and
thereafter the process stalls.
I visited Metalink and found out
i wanted a
script which contains the create table/schema's for a existing
database.
How to get this
script ? any utitlity or which option to be selected for achieving this after i
install Oralce ?
i am using oracle
8.1.7.
Thanks and regards,Santosh
It will show you the SQL atatements that are residing in the shared pool.
Once you flush shared pool all the statements cached there gets flushed, and
so V$SQLAREA will only show information about the queries which are currently
held by open cursors and are not flushed.
Regards
Naveen
-Origin
Dear All,
I wonder how long the life time of data in v$sqlarea. Is it a cumulative data
collecting in v$sqlarea since last database startup?or do the data in v$sqlarea only
reflect some recently data in Least Recetly List?
Why do I ask this is after I used "alter system flush shared_pool", I
At 06:08 AM 10/24/2002, MURAT BALKAS wrote:
Hi,
how can I be sure that the connection between our web server and
Oracle Server to be secure. What's the best method to accomplish this?
Any good links for "Oracle Nwtwork Security".
I'd start with the "Oracle Advanced Security Admini
Steve, You can create a RAC environment on SUN if you
get can get the necessary software. The hardware for
SUN is easy to get if you purchase it for eBay but the
clustering software is whole other story.
You need Sun Cluster 3.0 and and a LVM for the disks.
Getting SC3.0 may be easy but the LVM us
I know this novice question for dba's but just wanted to refresh this ,
what is difference between SID and DATABASE_NAME , why init.ora file shouldhave database name same as SID and in what circumstances SID and DB_NAME can be different .
TIA
oramagic Do you Yahoo!?
Y! Web Hosting - Let the expert
9i -- dbms_redefinition
should do it for you :)
--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Yeah, well the developers are always pi$$ed about something anyway.
> ;-)
>
> Seriously, good point, I've been spoiled, because most of my
> applications
> have kept the RI in the application as wa
Stephane,
It's easy if there is only one level of dependency... but what if (as
they did in one of my systems) there are levels of dependency? It's
sort of like trying to write (or rewrite) the ideptree view. Only you
have to save off the scripts, in the proper order. Oh yes, don't forget
views an
Stephane,
Well spoken- my bad. Our developer threw me this question when I was
just leaving from work. (I copied her email to the list) Now I am at
home and taking a chance to look it over again. I am not sure what she
asked for. My guess is she wants to pass a variable based on @xxx to
access t
Stephane,
Well spoken- my bad. Our developer threw me this question when I was just
leaving from work. ( I copied from her email) Now I am at home to look it over.
I am not clear what she asked for. I think she wants to pass a variable based
on the @xxx to access this schema. I will make it cl
Chris,
Our favourite footer (at a previous project) was:
#EOF#...
Sometimes there were no numerical columns, sometimes 1 and sometimes 12 or
more. In most cases we were the recipients of the files, so we wrote a
utility that created the footer based on an input specification. When we
received
Unfortunately it is a trust issue...
Trust me when I say a file can get scrambled. I have seen it happen. In
our wierdest scenario two received files appeared to be merged into a
single file - on the source system they had two intact files, on our system
1.5 files merged into a single file and .
Title: RE: Streams
The supplemental logging information adds quite a bit of into to each record.
1) it writes the actual column offset, rather than the logical offset (which it needs to query to find)
2) it writes the original head rowid for the row in addition/or instead of the rowid for the
Test first
We discovered a bug on Tru64 that prevented this from working correctly
in at least a couple versions of Oracle. 8.1.7 was suppossed to fix
this, but it didn't. 8.1.7.3 did *I think*.
>>> [EMAIL PROTECTED] 10/16/02 11:39AM >>>
You can use the 'higher' version of the listener for
I am trying to insert data into a remote table through a database
link.
This is the SQL and the error. 'dba_checks' is a synonym for the
remote table. Two prior inserts in the script work just fine.
MAILER is the name of the remote database.
I'm puzzled. Any suggestions?
Thanks,
Mike
SQL> l
The statement about "no performance impact on the database being replicated
from" may not be entirely accurate. In order to work, Oracle Streams (which
uses Log Miner) needs "supplemental" redo data to be generated by the
originating system, resulting from the ALTER DATABASE ADD SUPPLEMENTAL LOG
D
Joan Hsieh wrote:
>
> Hi Listers,
>
> I am trying to find a way to know the schema name. Say, if I logged in
> as jjin01@ngd. When I run a program, how can I get the schema name
> which should be "ngd"? If I logged in as bkrasnof@pr, in this case, the
> schema name will be "pr".
>
> Thanks in a
Nice website, but the basic flaw with such formulas
is what to input into the field marked "average row size"...
If you know the "average row size", then you must
already have a sample of data present in a table somewhere. After all,
without actual data already in an Oracle table, you coul
David - I recently discussed this with an industry expert. Here is my note
from that conversation:
"Look at Oracle Streams, which uses Oracle's Advanced Queuing facility.
This may be available in Standard Edition. The architecture is log-based,
similar to Quest Shareplex. This means that it has
Chris - Your comment about the other systems maybe sending you the wrong
file sparked an idea. XML! Yeah, it has been overhyped, but the basic idea
is that the file specifies the format. So you could get a file and ensure
the content conforms to your expectation. I am an XML novice, but I believe
y
Title: RE: Flat file generation integrity ideas...
DBMS_OBFUSCATION_TOOLKIT has an (undocumented)
function called MD5 which uses that protocol (MD5) to calculate checksums.
Look at $OH/rdbms/admin/dbmsobtk.sql...
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple
Stephane - You asked:
But why the second CTAS ? What about RENAME ? Seems faster to me ...
Well, it depends on whether you are okay with changing locations of the
table. Personally, I'm with you, just accomplish everything with one move of
the data. But I figured someone would object, insisti
Yeah, well the developers are always pi$$ed about something anyway. ;-)
Seriously, good point, I've been spoiled, because most of my applications
have kept the RI in the application as was being discussed earlier. Now they
are switching to Java and in future projects will be implementing RI in
Ora
Title: Message
Well,
it's kinda like saying your backups will never fail. The backup script
works now, and it has for many months, so I should never worry.
Right?
Well
I'm paranoid, and Andy Groove is my god. So I have to put in place some
checks to make sure the data is ok, before I l
Rachel Carmichael wrote:
>
> Dennis,
>
> That's a good thought, and it works if you don't have grants,
> constraints or dependencies on the original table.
>
> If you drop table1, you lose them all
>
> Rachel
>
> --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> > Deepak, If there are many colu
Hey Gang...
If you have a SAP instance, what is your listener port?
Our SAP systems listen on 1527. All six of them. Yesterday, one
of the SAP/R3 admins asked us why we use 1527 instead of 1521. I
told her I thought it was a SAP requirement because it pre-dates
my working here. None of the ot
WOW! I just got this one!! SLOW today...
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you.
---
I run my SYSTEM tablesaces in autoextend, and have for some time. I run them
that way from the point of database creation and have never had a problem.
There were some problems with autoextend in earlier versions of 8 (and I
think they managed to migrate to early 8i versions as well) with 2GB
bound
Rick,
For the first question, if you are looking to estimate the size of the
table, check out http://www.suhas.com/tsize.html
Raj
Rick_Cale@team
Hi Listers,
I am trying to find a way to know the schema name. Say, if I logged in
as jjin01@ngd. When I run a program, how can I get the schema name
which should be "ngd"? If I logged in as bkrasnof@pr, in this case, the
schema name will be "pr".
Thanks in advance,
Joan
--
Please see the offi
Johnson,
Auditing, atleast in 8i, wont help. Maybe, if its not an overhead, you
could have a logon trigger that enables tracing for those users.
Raj
Johns
Even more interesting is that I never saw the original comment from
Rachel... my email to/from Oracle-L seems to really be slow! Thanks Rachel.
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
L
Hello all
How can I run startup.bat file when database is up.
I tried using the HOST command in trigger but it does not work.
Something like: 'host d:\oracle\scripts\startup.bat' in the trigger.
Win2000, Oracle 8.1.7 or 9.2.0.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http:/
Just a note that my new book Oracle9i RMAN Backup and Recovery (with
co-author Matthew Hart) is out now! Enjoy!
And remember, if you like it, I wrote it. If you don't like it..
hm let's see then Tim Gorman wrote it.
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX
but we
did not download or install it.>>> [EMAIL PROTECTED]
10/24/02 10:39:07 AM >>>See:http://www.rational.com/products/purify_nt/index.jspI
think this is what they are talking about.RFRobert G. Freeman -
Oracle OCPOracle Database ArchitectCSX Midtier Database
AdministrationAuthor of severa
Raj;
Here is a link to the SNMP Support Reference Guide that Ray talked about
for 8.1.7. I am sure its probably somewhere on your Documentation CD for
your version.
http://www.cosc.canterbury.ac.nz/docs/oracle/server.817/em.817/a85249.pdf
All I did was search the web for "Oracle SNMP Support
Large Software Company in Atlanta, Georgia needs an Oracle DBA /Developer with
solid 9i experience to join its' IT staff.
This is an excellent company that will pay relocation expenses.
PLEASE Do Not send your resume for this position UNLESS you have the skills
outlined
below for this position.
now now, play nice!
--- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> Just a note that my new book Oracle9i RMAN Backup and Recovery (with
> co-author Matthew Hart) is out now! Enjoy!
>
> And remember, if you like it, I wrote it. If you don't like it..
> hm let's see then Tim Go
Where?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 4:44 PM
Just a note that my new book Oracle9i RMAN Backup and Recovery (with
co-author Matthew Hart) is out now! Enjoy!
And remember, if you like
Hi
Can some one suggest whats wrong in this query?The same query run fine on
development db but not running on production?
select count(a.xxx_id)
from gorp_cats_stats_view a ,
static_pages b
where b.xxx_id = a.xxx_id
andb.words like '%test%'
anda.main not like '%test%'
anda.u
To me this comes under the heading of "common sense".
My $0.02 worth,
Ken Janusz, CPIM
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 9:33 AM
As this topic just hits my hot button, I'm going to chime in my 2 cents
wo
These days . just hire a 15 year old kid with a computer at home He
might do beter than an expensive 'security firm' ...
-Original Message-
Sent: Thursday, October 24, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L
Hire a special company that handle this.
We are doing it
Title: RE: Oracle Real Application Clusters
We had the user which owns oracle was nfs mounted across two machines using nfs. i.e. user oraclei home directory was nfs mounted across tow machines. When we used srvctl to start instances occasionally it used to hang when bringing up the 'other sid
Could you use an external procedure or java call? Metalink & Tom Kyte's book
have good examples.
-Original Message-
Sent: Thursday, October 24, 2002 9:29 AM
To: Multiple recipients of list ORACLE-L
Hello all
How can I run startup.bat file when database is up.
I tried using the HOST comm
Any follks have reviews on the book Oracle Performance
Tuning written by Edward Whalen & Mitchell Schroter
and published by Addison-Wesley?
Saw a blurb in the recent issue of Ora Mag.
Thanks
mkb
__
Do you Yahoo!?
Y! Web Hosting - Let the expert h
As I said, use mssql ONLY if your boss is willing to be strapped into a
MicroSlop only platform. If he's even remotely thinking of using a different OS
then you can't use mssql.
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 10/23/2002 1
Title: Flat file generation integrity ideas...
I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed.
I am looking for ideas on how to ensure data integrity in the flat files.
For example, the expected record
The easiest solution I can think of is to set spool off within the
script.
Dennis
Charu Joshi wrote:
>
> Dear Listers,
>
> Given below is a script that I execute from within SQL*Plus for WinNT:
>
> temp.sql:
> -
> set echo off
> set pagesize 0
> set feedback off
> SELECT * FROM tab W
Man, I can't think of a thing that would cause this.
I'd suggest running tkprof or somesuch on the query in both environments but
it probably wouldn't do any good.
Comparing indexes? Nah, forget it. Not worth the time.
What else, what else???
--Walt Weaver
Bozeman, Montana
-Original Mess
Title: RE: RMAN - It's Here
do list members get a "I post where you post" discount? =)
-Original Message-
From: Freeman, Robert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 24, 2002 10:44 AM
To: Multiple recipients of list ORACLE-L
Subject: RMAN - It's Here
Just a note that
Sorry for the mistake. the question was wrong. :(
The right question should be :
How can I secure the connection between our web server and Oracle Server?
Is there any chance to solve this issue with Oracle related solutions or
should I use IPsec or smth like that about network security.
Murat
Has anyone started using the Oracle streams feature? I'm wondering how this
compares to Advanced Rep. I am guessing this approach will provide better
performance but thought I'd check with the list to see if someone can confirm
this.
Thanks, Dave
--
Please see the official ORACLE-L FAQ: http://w
Dear Listers,
Given below is a script that I execute from within SQL*Plus for WinNT:
temp.sql:
-
set echo off
set pagesize 0
set feedback off
SELECT * FROM tab WHERE ROWNUM < 10;
set pagesize 1000
set feedback on
set echo on
-
While running it always displays 'SQL>set echo off' b
Hi,
What error are you getting? Just saying 'not running in production' doesn't give any
clue to answer.
Regards,
Sandeep
-Original Message-
Sent: Thursday, October 24, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L
Hi
Can some one suggest whats wrong in this query?The same q
Amazon.com, Oraclepressbooks.com, etc...
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you.
-Or
Seema
Have you run an explain plan?
Your query will likely do a full-table scan of both tables. Are they
large?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, October 24, 2002 11:40 AM
To: Multiple recipients of list ORAC
Different data? Missing indexes?
What do you mean "Something's Wrong"?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, October 24, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L
Hi
Can some one suggest whats wrong in this query?The same query r
Chris - I would consider checksums. Many systems have built-in checksum
functions. On Unix these are cksum and sum. You could probably write a
simple one that would work on your various systems. Search for checksum and
somewhere on the Internet is probably sample code for one in a language that
wil
I solved the problem by:
Call a Java function that sends the command to a service that activate the
command as a process in NT.
This was written by another of my team and can send the command to any
computer on the NT network.
I think that Joe asked about open window when applying archive logs to
Title: Flat file generation integrity ideas...
Chris,
have
you thought about summing a number column in the record and placing this
sum in a trailer record? this way, you have a header and trailer record
which helps you be confident that the whole file made it to the target
system. and b
Title: RE: Flat file generation integrity ideas...
you could also use dbms_utility.get_hash_value ... to compute hash value for the whole row and store that as an additional column. Be syre to use the same parameters on both sides to compute and test, else it will fail the check.
Raj
Title: RE: QUERY?
Without a clearer description of what it isn't doing, my WAG is missing permissions on the views or tables.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
On Thu, Oct 24, 2002 at 06:53:27AM -0800, Tim Gorman wrote:
> NetApp is NFS; so are all current NAS products...
>
> The phrases "NetApp" and "cheap" are *always* used together -- it is their
> most compelling feature. CFOs love NetApps. For database usage however,
The netapp sales guy I talke
Why pay more, Try www.bookpool.com
Oracle9i RMAN Backup & Recovery
Freeman, et al / McGraw Hill / 2002 / 0072226625
Our Price $30.95 ~ You Save $19.04 (38% Off)
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 24 Oct 2002
Title: Message
(slapping my forehead) Duh.
Nice. I like it. Simple but effective. Minimal impact
on performance. And easy for the other systems to implement.
You da
man, Tom, I don't care what Jared and Rachel said about
you...
Thanks.
-Original Message-From: Merca
Hello All,
I have heard several times that if the SYSTEM tablespace runs out of space
and needs to autoextend (assuming autoextend is turned on for the data
file), then you run the risk of the database crashing and of data dictionary
corruption. I have never personally encountered this problem, s
Title: Flat file generation integrity ideas...
Chris;
I
would suggest the following:
1. Generating Check Sums of the files before they are sent.
2. Send the files.
3. Generating an after Check Sum and compare.
Here
are the steps I go thru to make sure our Oracle Archive Logs are c
I will have to keep those in mind, if I ever get back onto a UNIX
platform.
Right now, I'm sticking to Tom's suggestion because I religiously follow
KISS.
Thanks!!
-Original Message-
Sent: Thursday, October 24, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L
Chris - I would consi
I read in Note:97291.1 that db_writer_processes/db_block_lru_latches
could be set to match the number of cpus to try to impove db file
parallel write waits. Are seperate controllers required for this to
be effective? Any good refs on this topic.
=
I don't get that when running on W2K. Are you executing a login.sql or
glogin.sql script first? How are you invoking your temp.sql? Using the @
on the command line or redirecting input or typing it in directly?
What version of sqlplus? I tried it with 8.1.6.
Marc Perkowitz
- Original Mes
Title: Message
Yes,
Melissa also mentioned this to me. I will have to look into that
function...along with the million other procedures and functions that
Oracle has. At this point, Tom's suggestion seems to be the
simpliest/effective/fastest. Any other suggestions?
-Original Me
Ups colegas !
@lex
Lic. Alexander Ordóñez Arroyo
Soporte Tru64Unix & BD Oracle
Caja Costarricense del Seguro Social
Telefono: 295-2004, San José, Costa Rica
[EMAIL
To do an import from a full export of a database, do the tablespaces already
need to be set up before the import? How can you query the database to get
the tablespace name and the total space needed for each tablespace?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mi
Title: RE: LOCALLY MANAGED TABLESPACE
Metalink Note: 93771.1
-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 24, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L
Subject: LOCALLY MANAGED TABLESPACE
Hi
I am thinking to change our few dic
Why do you always SHOUT in your subject line?
Or are you not aware of simple net-etiquettes?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 2:49 PM
> Hi
> I am thinking to change our few dictinary manages tablespace to
because the author's royalties are based in part on what the book sells
for?
just doing my part to keep Robert's kids fed :)
--- Mohammad Rafiq <[EMAIL PROTECTED]> wrote:
> Why pay more, Try www.bookpool.com
>
>
> Oracle9i RMAN Backup & Recovery
>Freeman, et al / McGraw Hill / 2002 / 00722
Title: Message
Trouble with this is that there is a possibility that a change in the
number in the file could result in the same sum.
Then
you have different data but your checks says everything is ok.
Checksums are far more accurate.
-Original Message-From: Grabowy, Chris
Maybe someone beside the author can answer this question:
I'm confused about how to connect to a database using Jared's PDBA
toolkit. The various utilities specify command-line options -machine
and -database. There's a PDBA::CM connection manager module that can
be used to specify environment va
Full import will rebuild the tablespaces.
browse the export file and you will see the commands inside.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 9:25 PM
> To do an import from a full export of a
Hello Sam
I do not know specifically about SYSTEM tablespace but from a bitter
experience beware of the 4GB limit. if a datafile on NT/2000 autoextend
beyond a multiple of 4GB (8,12...) then that datafile is GONE. We had a
production database crashing on this problem and had to call in Oracle with
Chris - If Tom's idea provides you the protection you require, with
convenience to boot, then it sounds like you have a winner. I think all the
suggestions provide some variety of checksum, a standard computer science
technique. What are your requirements? Mainly to make sure the file doesn't
get t
Seema - While you are planning your conversion, be sure to carefully read
the paper:
How to stop defragmenting and start living: The definitive word on
fragmentation by Himatsingka and Loaiza so you really understand how to
receive the benefits of LMTs.
It is available on http://www.hotsos.com
an
Mike - Yes, you need to create those tablespaces first. If the tablespace
isn't there, import will default to the default tablespace of the username
that is running the import. Select bytes from dba_data_files to find the
tablespace sizes.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECT
We have a need to
change the datatype of several columns in a table from number to
varchar2. Most of the rows have data in these columns hence a direct 'alter
table ...' will not work.
We plan to create a
temp table, move the data from these colums to that table, modify the
column dataty
Thank you for your help. I follow your instruction and granr privilege. It
fixed me a lot of errors. Currently, I have another problem still create
view problem.
SQL> CREATE OR REPLACE VIEW WWV_DBA_SGA ( COMPONENT_GROUP,
2 MEMORY_SIZE_IN_BYTES ) AS select name component_group, bytes
memory
Title: Flat file generation integrity ideas...
I do not see how the file can get
"scrambled".
You write it out ok.
The ftp is guaranteed.
So what is the problem.
I will go along with the suggestion to zip it. It saves on
the ftp time and also gives you some protection.
Yechiel AdarMehish
Sam,
Autoextend caused tablespace corruption for me once, but it was over 5
years ago with Personal Oracle 7.3.2.3 on Win95 - not the most reliable OS
that Oracle has ever ported to. ;-)
We have several 8.1.7 databases here, on both Win2k and HPUX. Autoextend,
even on System, has caused no pr
Rachel,
Interesting, I never thought of it. I feel sorry for that if it is reducing
royalty of Roberts, but my intention was different and to help others to
reduce their cost of this book. Besides I am very much satisfied with the
services/prices of bookpool.com
Regards
Rafiq
Reply
Mike,
While not necessary, it would be a good idea to precreate the tablespaces.
Else, for a clean import the first time, you would need to ensure that the
directory structure for the datafiles exists, you have the permissions to
create files at the OS level, ensure that files dont already exist
Hi DBAs,
Does anyone have a table & index sizing utility program/script they can
share?
Also where can I find out exactly how much storage Oracle allocates for
every datatype? I checked the concepts manual but could not
find it.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.
Sam -
I haven't made the system tablespace autoextend because I can't easily
recover the space if it overextends. I would rather take the risk that
something hits an error from a lack of space in the system tablespace. With
other tablespaces you can always rebuild the tablespace if you need to.
Seema,
Our production Student Information database (8.1.7 under Win2k) has 40,000
tables and 60,000 indexes. It's a third party app designed for dBaseIV -
go ahead and laugh, we do all the time (when we're not crying). Anyhow, we
have to regularly clone out the data to a couple of other databas
Deepak, If there are many columns on these tables, your method may be best.
However, this will generate a lot of redo. You can usually accomplish this
with a CTAS nologging, which won't generate redo. If you really don't want
to change the location, you can:
create table temp as select * from t
Hi all,
We were trying to find a way to get all queries by a
group of users of the database. Auditing the users
lets us know whether they ran a 'select' 'update' etc.
but not the full text of the query. This is in 8i.
9i seems to have a view called DBA_FGA_AUDIT_TRAIL
which has a SQL_TEXT column.
Rafiq,
I was teasing... I buy books from discount places as well. Including
bookpool
Rachel
--- Mohammad Rafiq <[EMAIL PROTECTED]> wrote:
> Rachel,
>
> Interesting, I never thought of it. I feel sorry for that if it is
> reducing
> royalty of Roberts, but my intention was different and to he
Rachel,
Thanks. Basically I don't like Amazon because of various reasons and my bad
experience with them. Besides , we normally buy technical books at our own
so everybody try to reduce their cost, Right
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORA
Rick - I'm sure there are a lot of good sizing programs around. And hey,
awhile back I was just as anal as everyone else, struggling to estimate
everything to the last K. I've got another idea for you to consider. If you
switch to LMTs and autoextend, then you don't need to spend nearly as much
tim
I buy lots of books from Bookpool!! :-) I buy from Amazon too but those are
normally non technical books.
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
Londo Mollari: Ah, arrogance and st
Dennis,
That's a good thought, and it works if you don't have grants,
constraints or dependencies on the original table.
If you drop table1, you lose them all
Rachel
--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Deepak, If there are many columns on these tables, your method may be
> best.
>
1 - 100 of 130 matches
Mail list logo
