Re: SELECT statement...

Hi Rich, I doubt any NULL value being checked in the WHERE CLAUSE... as u will be knowing a NULL is not equal to another NULL in oracle !! Just try applying NVL on such possible columns Hope this may help u. regards, Arul. Richard Huntley wrote: I'm encountering something very

Re: ORA-27072

Hi all... Yess I have veritas backup utility in that machine . I have disabled that and waiting now . Still now there is no problem Thanks to all who responded !! regards, shibu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shibu INET: [EMAIL

RE: Pinning Packages in the Shared Pool??

Title: RE: Pinning Packages in the Shared Pool?? John, I understand this still to be true or at least I have never heard anything to oppose it. Looking at the latest book I have purchased (101 Performance Tuning) the authors do talk about the principle and state many database administrators

Re: moving from unix to NT

Hi John, We did the reverse way ie from NT to unix we migrated. Basically, take care of the path ie '/' to '\' in UTL_FILE. Re-compile and create the DLL in NT. Then recreate the library associated with the DLL. Jobs will run fine. But make sure you re-submit them, HTH Venkat -- On Mon, 25

Re: DBMS_STATS in 8.1.6

Well, it has some bugs with GATHER EMPTY and GATHER STALE on your release. However, I set it in some clients and it is working fine. As an advice, don't use those options, reduce the size of the bucket just to generate statistics quickly, lastly if you decide against DBMS_STATS, don't run

Sites worth visiting

For those who don't know yet... www.oracle-base.com www.oracledba.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: SELECT statement...

Title: RE: SELECT statement... Hi, Count(*) will never return NO_DATA_FOUND..so NULL value being compared is out of question Viral. -Original Message- From: Arul kumar [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 1:28 PM To: Multiple recipients of list ORACLE-L

Updating a non-Oracle DB using Oracle

Title: Updating a non-Oracle DB using Oracle Hi, We want to update/insert a table made in foxpro/Clipper using Oracle SQL. We can select from such a table using heterogeneous services of Oracle8i, but we were not able to update them. Is there a way we can do that, using ODBC, heterogeneous

A link to Oracle 9i Database documentation.

http://download-west.oracle.com/otndoc/oracle9i/901_doc/nav/docindex.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: SELECT statement...

Title: RE: SELECT statement... Thanks Viral Arul, but my thoughts EXACTLY. Oddly enough, it is indeed happening. The SELECT statement ALWAYS causes a NO_DATA_FOUND exception even when I alter it and use nvl around the count(*), which shouldn't be necessary and even around the :new.stuid

RE: SELECT statement...

Can you post your trigger so we can see what else is happening? I do not see where having the SELECT as you have posted to be of any use in a trigger. I think in order to get a NO DATA FOUND error in a trigger from SELECT COUNT(*)... would be if it was a cursor. Rick

RE: ROWID datatype columns and primary keys

Another thing that I recall, if I am correct, the freed ROWIDs (after deleting rows) are assigned to newly inserted rows. Aleem -Original Message- Sent: Thursday, February 21, 2002 11:18 PM To: Multiple recipients of list ORACLE-L Subject:ROWID datatype columns and

RE: DBMS_STATS in 8.1.6

DBMS_STATS only gathers stats that the optimizer needs. For example, the CHAIN_CNT field is not updated because the optimizer doesn't need it. I hate this because now I don't know if the table has chained or migrated rows. The ANALYZE command still gives you this information. -Original

Raster Data in Oracle Spatial - Second Try

I posted this last week and didn't see it coming up. Here's hoping someone can help I am getting some conflicting answers to what I deem to be a fairly simple question. Does Oracle Spatial support storage of georeferenced raster data? We are looking at this in particular to reference to GIS

RE: SELECT statement...

Here is the trigger code, thanks. CREATE OR REPLACE TRIGGER check_student_grp BEFORE INSERT ON course_activity FOR EACH ROW DECLARE v_vDPECError dpec_errors_table.error_description%TYPE; v_nDPECErrorCode dpec_errors_table.error_code%TYPE; v_vDPECActiondpec_errors_table.error_action%TYPE;

Re:Database Query Tool

Mike, There are a lot of tools like that on the market. My favorite for several years was Discoverer or Oracle Browser as it was then known. Recently though I've switched camps to Brio One from Brio Technology. Reason, Discoverer is part parcel with 9IAS Enterprise that product is an

Re: moving from unix to NT

Well, you shouldn't:) Because Oracle on NT runs (hence executes UTL_FILE) under SYSTEM account, which does not have privileges to access network drives. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday,

UWIN and Oracle

Hi Gurus, Any body got any experience using UWIN on NT with oracle. I can't seem to do anything like starting sqlplus, svrmgrl or lsnrctl.. Any hints/suggestions will be most welcome. I am trying out the eval of ver2.9. Thanks Anjan begin:vcard n:Thakuria;Anjan tel;work:817-963-3291

RE: DBMS_STATS in 8.1.6

Thanks for the advice, Christian, but I'm a little confused. What do you mean by don't run statistics with analyze because it doesn't generate any? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA

RE: object-oriented vs semantic database model

Roy , if at all possible, would you please share the doc after u finish it. Thanks a lot ! -Original Message- Sent: 25 February 2002 18:23 To: Multiple recipients of list ORACLE-L all, I am doing a writeup on comparing and contrasting the object-oriented database model and the

RE: moving from unix to NT

DBMS_JOB works fine on NT for me. DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: 25 February 2002 19:33 To: Multiple recipients of list ORACLE-L I suspect that directory changes, etc. should be the only issues you will need to work through.

Re: UWIN and Oracle

Hi Anjan, We did use it in the good old days... 1999 or so! :-) Although we did get those things working with uwin, it was more or less by executing cmd and then executing those things. Not really clean, or what you're hoping for, no doubt. However, I must warn you: we had a serious production

RE: UWIN and Oracle

Title: RE: UWIN and Oracle Have you made sure that your path variable is set correctly? If I recall I was able to use all of the oracle command line tools through uwin. Please double check your .profile file and make sure that your oracle bin directory is included. Or you can check to see if

Re: moving from unix to NT

DBMS_JOB works fine for me too on NT. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 5:34 PM DBMS_JOB works fine on NT for me. DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED]

DISREGARD, JUST A TEST

TEST ONLY

How to restart SNMP daemon process

How do I restart a daemon process on UNIX if it dies? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

address parse

Title: RE: UWIN and Oracle Anybody already have an address string parser (plsql) already written that they would care to share?

RE: How to restart SNMP daemon process

on Tru64 /sbin/init.d/snmpd start -Original Message- Sent: February 26, 2002 8:08 AM To: Multiple recipients of list ORACLE-L How do I restart a daemon process on UNIX if it dies? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Re: How to restart SNMP daemon process

N How do I restart a daemon process on UNIX if it dies? First, knowing why it died is a good thing. Especially when it's SNMP for the last couple of weeks. Most implementations have a vulnerability that the vendors have been pumping patches out for. But to answer your question, when this

Anybody immigrated to Australia.

Firstly sorry about the irrelevant post on the list. But this is my only chance. I am wondering if there is anybody on the list who migrated to Australia or living there now. Because I will ask some questions about immigration process and the probability to find a job in Australia, I want

Re: address parse

S Anybody already have an address string parser (plsql) already written that S they would care to share? Address? IP? Internet mail? USPS? Memory address? URL? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City

RE: DBMS_STATS in 8.1.6

Sorry, I haven't explained myself correctly. When you have first run a dbms_stats to generate on partitioned tables, analyze doesn't generate any. However, this applies for compute statistics. I think this article could explain you better than I: Doc ID: Note:97207.1 Type: PROBLEM Status:

Re: How to restart SNMP daemon process

something along the lines of: /sbin/init.d/snmpd start your mileage my vary. Also, be aware of the huge snmp security threat that was announced a few weeks back: http://www.cert.org/advisories/CA-2002-03.html On Tue, Feb 26, 2002 at 08:08:24AM -0800, Nguyen, David M wrote: How do I

Re: moving from unix to NT

Because Oracle on NT runs (hence executes UTL_FILE) under SYSTEM account, which does not have privileges to access network drives. You can change that if you're so inclined. ( I can't believe I'm defending Windoze. shudder ) Jared Igor Neyman [EMAIL PROTECTED] Sent by: [EMAIL

RE: Database Query Tool

You might try Oracle's Query Builder product. It seems to be an upgraded version of the old Oracle Browser. Its part of the Developer 6i package. You can download Developer 6i at http:\\technet.oracle.com to see if you like it. They have one for NT but it seems to run well on Win95/98 and XP

RE: Database Query Tool

Mike - One critical question - Will you be creating reports for the users or will they be creating the reports by themselves? We have had a lot of trouble where IS would buy a query or reporting tool with the idea that the users would be self-sufficient. Then it turns out that IS uses the tool.

Re: moving from unix to NT

Well, I was having all kinds of problems, when I was playing with this option, trying to make oracle service on nt to run under other then SYSTEM account. And yes, I granted this account any possible NT privilege (like ability to run/logon as a service), still didn't work. Jared, Could you

RE: address parse

street address -Original Message- Sent: Tuesday, February 26, 2002 10:55 AM To: Multiple recipients of list ORACLE-L S Anybody already have an address string parser (plsql) already written that S they would care to share? Address? IP? Internet mail? USPS? Memory address? URL?

Problem running a report

Hi, ladies and gentlemen, Here is a good one. We have 25 offices nation wide, running similar reports. At the headquarters the one in consideration takes 12 min to complete. Any other office (WAN) it gets stuck and takes a few hours if it completes at all. Here is the output from

RE: Database Query Tool

Dennis, You are absolutely correct. These users know nothing of SQL and will probably never be able (due to lack of interest) to do more than change search parameters in queries that I write and provide to them. They need access to Oracle to validate the transfer of data from IMS on the

RE: address parse

And what would you like this parser to do? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, February 26, 2002 2:03 PM To: Multiple recipients of list ORACLE-L street address -Original Message- Sent: Tuesday, February 26, 2002 10:55 AM To:

Control File locks

I noticed that my users are occasionally (once or twice a day) acquiring a 'CF' lock. According to the oracle reference, 'CF' lock is a Control File lock. Does anyone know why would users acquire a 'CF' lock, or in one case, even a 'IS' (Instance State) lock? What situation can lead to

RE: Problem running a report

That wait is, essentially, an idle wait. That means that the database processes are waiting for the message from the client, which, quite obviously, is taking it's time. Yes, I think that getting yourself a Snoopy (network engineer with a packet sniffer) would probably be a good idea.

Users reading from rollback segments

Is there a way to tell if anyone is reading from the rollback segments? I would like to manually issue 'alter rollback segment XXX shrink;', but do not want to do so if there are users reading read consistent data from the rollback space (thus giving them the ORA-01555 error). Is there a

RE: ftp from unix session to your local harddrive-How?

I am very happy with the product WS-FTP from www.ipswitch.com for transfering files to and from unix /windoz. It has a trial period and the registered product is very inexpensive. ROR mª¿ªm [EMAIL PROTECTED] 02/25/02 03:45PM You'd need to run an FTP server on your local machine - do a search

Re: Problem running a report

Are you using remote connections to a centralized database, or does each office have its own database? Tracert and netstat commands should help you figure out if its a network issue. Regards Raj

Need some white papers on replication

Hi All, i really need some papers on replication and any book recommendations. TiA!! -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

RE: Control File locks

Here is what Ixora has to say on Controlfile waits: Wait event: refresh controlfile command The refresh controlfile command wait event is not important for tuning, but can be helpful in problem diagnosis. It occurs when mounting a database, and when a controlfile transaction changes the

Re: Problem running a report

Look at v$session_event for session 82. That will tell the story . Anjo. "Babich , Sergey" wrote: Hi, ladies and gentlemen, Here is a good one. We have 25 offices nation wide, running similar reports. At the headquarters the one in consideration takes 12 min to complete. Any other

RE: Problem running a report

Thank you, Mladen. It's always good to know that the guess was right -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Subject: RE: Problem running a report That wait is,

RE: Users reading from rollback segments

Why would you want to shrink a rollback segment? -Original Message- From: Glenn Travis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Subject: Users reading from rollback segments Is there a way to tell if anyone is

Re: Users reading from rollback segments

To partially answer your question, xacts in v$rollstat will tell you if there are any active transactions in the rollback segment. Raj Glenn Travis

RE: Control File locks

This is from Oracle Metal Link. The CF locks are used to serialize controlfile transactions and read and writes on shared portions of the controlfile. For example, these locks would be used for - switching logfiles, held exclusive. - updating checkpoint information for datafiles, held

Re: Users reading from rollback segments

Is there a way to check if the rollback segment is in use first? I use following script to see which rollbacks are in use...and then shrink to certain size if it requires to do that... select substr(a.os_user_name,1,8) OS User ,substr(e.username,1,8) DB User , substr(b.object_name,1,30)

RE: Problem running a report

Thanks to everyone who responded. The database is centralized. Yesterday I PINGed some machines in different offices (and TRACERTed, too) right from the server, and the response time was under 100 msec. However, some offices reported it to have run normally. That particular report creates a big

Re[2]: address parse

Shaw, S street address How is it formatted? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /

Re: Control File locks

There are two locks: a read lock and a write lock. So most of the times when you read the Controlfile you will get the CF enqueue in mode 4. If you update the control file, you get it in mode 6. Now the reasons why could be plenty but most likely to identifying or re-identifying database files

RE: Re[2]: address parse

usually street number street name and street type, but it could also include street prefix , apartment number, and directional suffix. -Original Message- Sent: Tuesday, February 26, 2002 2:30 PM To: Multiple recipients of list ORACLE-L Shaw, S street address How is it formatted? --

Global variable in Pl/SQL

Dear list ! How can i make a package variable visible to all sessions , please ? I.e. i have a package PPP that has a package variable VVV. There is a stored proc in the package , PPP.SP1 In this procedure i set the package variable VVV to some value. Now , i want all the sessions connected to

Re: Users reading from rollback segments

SELECT segment_name, USN,EXTENTS,RSSIZE,HWMSIZE,optsize,xacts,aveactive,WRAPS,shrinks FROM V$ROLLSTAT, dba_rollback_segs where usn=segment_id xacts =1 is in use. otherwise it is 0. oracle 8.1.6 you can take an active rollback segment offline, but also kill the transaction. 8.17 supposed to fix

Function based indexes

Hi, everyone, This may seem very simple to you, but what's the best way to see if a fresh FBI (sorry!) is used during the execution? Are they reported in the same manner to the SQL trace as other ones? Regards, Sergey

UPGRADATION

Hi I am running oracle 8i standared edition.I want to upgrade to oracle 8i enterprise edition.IS this possible on same oracle home? If not then can I install oracle 8i enterprise edition into another oracle home? Thx _ Send and

RE: Need some white papers on replication

Bill, I'm starting on this also and it seems to me that Oracle Doc is not bad. Waleed -Original Message- Sent: Tuesday, February 26, 2002 2:53 PM To: Multiple recipients of list ORACLE-L Hi All, i really need some papers on replication and any book recommendations. TiA!!

RE: Users reading from rollback segments

Thanks for the replies. I have all sorts of neat queries (which I can post) which show me gobs of information about my rollback segments (sizes, extents, optimal, shrinks, active transactions, block used by those transcations, ad infinitum...). HOWEVER, I still cannot find an answer to my

Re[2]: address parse

John, We're actually messing with you a little bit, having fun at your incomplete question. Not only are there many things that could be considered an address, some of them have several components that could be combined in several different ways. Not only that, but there are different ways

Re: Control File locks

Last year when I worked at a internet company. We had same problem. CF constantly get locked. Steve asked me to run this query. I am not sure it will help you or not? But at least it give you some idea which sql caused the lock. It was a mystery for us, never get solved. By the way, do you have

RE: Users reading from rollback segments

XACTS is the NUMBER of active transactions in the rollback segment. 0 or 0. However, I am not looking for transactions, I am looking for queries reading from the rollback space for read consistency purposes. I found an answer to my second question and it is NO. You can take the rollback

RE: Need some white papers on replication

Bill: Anita Bardeen's Replication DOs and DON'Ts is excellent. All of Lawrence To's White Papers are good Graceful Switchover and Switchback, Oracle Standby Database Oracle8i Standby Database Mission Critical Recovery Within 30 Minutes I believe these are all on Metalink.

RE: Control File locks

Nope. The user doesn't have the DBA privilege, necessary for any of these operations. The problem is that ordinary, non-DBA users are acquiring a CF lock. I asure you that users could not be doing any of the things here. That's precisely what puzzles me so greatly. -Original

Re: moving from unix to NT

I haven't tried to do this with Oracle, I just knew that you could. My use has been to change the account that is used for some of my monitors that need to see network drives. I've never had a need to make Oracle run as other than System. As for UTL_FILE, I avoid it like the plague. Perl is

RE: Need some white papers on replication

Title: RE: Need some white papers on replication Here are a couple http://www.quest.com/whitepapers/shareplex/ Not OAR... but a better solution. Nick -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 12:55 PM To: Multiple

Re: Users reading from rollback segments

Since you cannot predict who might need to generate consistent reads from the RBS in the FUTURE, you cannot predict if you will cause ORA-01555 or not by shrinking. Your best bet is to get rid of people bloating up RBSs by limiting their growth, and enforcing the use of smaller transactions.

RE: Global variable in Pl/SQL

Andrey, You can't make a PL/SQL variable value visible to all sessions. You'll have to put the value in a row in a table and commit it. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com

Re: Global variable in Pl/SQL

Quick answer: You cannot. Somewhat longer details: The implications of doing so are most likely not really what you want. Ever noticed the Oracle latches You would need to get into exactly the same trouble; who's allowed to write to that value? Oracle doesn't expose an API to

Re: Anybody immigrated to Australia.

Bunyamin, here's a link that should answer all your questions ... http://www.immi.gov.au/ Good Luck David McVeigh Bunyamin K. Karadeniz [EMAIL PROTECTED] 02/27/02 02:58am Firstly sorry about the irrelevant post on the list. But this is my only chance. I am wondering if there is anybody on

Re: moving from unix to NT

prior to 9i, you're stuck with utl_file_dir for logminer. as for utl_file, it has its place just rarely and for those of us perl-impaired(and having no desire to learn it), it works :) joe [EMAIL PROTECTED] wrote: I haven't tried to do this with Oracle, I just knew that you could. My

RE: Control File locks

Thanks, Anjo! -Original Message-From: Anjo Kolk [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 26, 2002 3:35 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Control File locksThere are two locks: a read lock and a write lock. So most of the times when you read

RE: Need some white papers on replication

Bill - The two books I have been able to locate are: Oracle Distributed Systems by Charles Dye, an O'Reilly book Data Replication - Tools and Techniques for Managing Distributed Information by Marie Buretta, a Wiley book -Original Message- Sent: Tuesday, February 26,

RE: Need some white papers on replication

Erm, Barb, I think your left pinky finger isn't quite on the homerow of your keyboard. Did you mean: www.orafaq.com/faqrepl.htm? :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original

RE: Control File locks

No, it's not a problem, it's just a matter of scientific interest. Your query looks very good, I like it. Who is Steve that you have mentioned in your post? -Original Message- From: Joan Hsieh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 4:12 PM To: Multiple

RE: Need some white papers on replication

A faw site is a frequently asked what-the-heck-is-that site. It's for those of us who are a bit more desperate. -- From: Jesse, Rich[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 3:01 PM To: Multiple recipients of list

Re: UWIN and Oracle

Thanks Ivan, But ./sqlplus does nothing. I get a couple of no msg found onthe lsnrctl and the svrmgrl. I am testing this utility to port our monitoring scripts to run on windows. If you could provide me with any help that will be greatly appreciated. Thanks Anjan [EMAIL PROTECTED] wrote: Have

Re:RE: Need some white papers on replication

Damn, another sales droid on the loose!! :-) Reply Separator Author: Nick Wagner [EMAIL PROTECTED] Date: 2/26/2002 1:36 PM Here are a couple http://www.quest.com/whitepapers/shareplex/ Not OAR... but a better solution. Nick -Original

Optimum I/O setup for control files.

Hi all, This has probably been beaten to death in a FAQ somewheres, but I can't seem to find it. For an 8.1.7 DB on Solaris8, I think I've got my file placement down except for the control files. As far as drives left unoccupied, I've got 2+2 (four) 36GB 10K (15K, maybe?) SCSIs. All 4 drives

RE: Users reading from rollback segments

People also obtain read consistency data from the rollback segments after transactions have committed. If a query began before someone else's transaction committed, but continues reading, then needs the reconstruct the data from before the commit, in needs rollback data that is both committed

RE: DBMS_STATS in 8.1.6

Does this apply in 8.1.7. I couldn't tell from the doco. Kathy -Original Message- Sent: Tuesday, February 26, 2002 9:28 AM To: Multiple recipients of list ORACLE-L Sorry, I haven't explained myself correctly. When you have first run a dbms_stats to generate on partitioned tables,

RE: Users reading from rollback segments

Glenn, An approximation of what you require *may* be worked out this way: 1. Snoop v$session_wait for all events that start with 'db file%' and see if P1 is in a list of data files that belongs to the RBS tablespace(s). If you do see sessions that have P1s indicating RBS files, then you *may*

RE: Users reading from rollback segments

John, I was thinking along the same lines, but then its not the sure shot way to do it. I was also wondering if one could instead do it with x$bh and dba_extents. Just a thought. Thanks Raj

RE: Users reading from rollback segments

Jeremiah is correct. In addition, rollback segments are read as part of the delayed block cleanout process, and it's not possible to predict that, either. --- Jeremiah Wilton [EMAIL PROTECTED] wrote: People also obtain read consistency data from the rollback segments after transactions have

Truncate and LMT

Hi everybody, I'm having a problem truncating tables in an LMT. The space is not deallocated when you truncate which appears to be a well documented problem on metalink. I can get around it with alter table ... deallocate unused keep 1k; The problem I have is that the index space isn't

Re: Sites worth visiting

Thanks for the information. Fazal --- Vladimir Barac - posao [EMAIL PROTECTED] wrote: For those who don't know yet... www.oracle-base.com www.oracledba.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL

Manager decrees his data warehouse design. Help!

I've lost patience, my temper, and I'm about to quit a job because the IT manager has decreed that we will have his data warehouse running within 24 hours, and we will use his design. 1 - We are NOT to use any kind of views, not even materailzed views. 2 - we are not to do any computations,