OraTechSupportGroup : Messages : 3-39 of 457

Messages: Simplify \| Expand (Group by Topic)		Author	Sort by Date

3	Hai! My name is Shiva, Prsently i am working in RAM Informatics Ltd. (Hyderabad-INDIA) as a DBA. Good to see all the professionals ids at one place. with...	shiv Sistla shivkrish27@...	Jul 3, 2001 4:41 am
4	Hi, I am getting the following trace file on HPUX BOX after every 5 minutes. /lvol/oracle/admin/nghpux2/udump/ora_3206_nghpux2.trc Oracle8i Enterprise Edition...	Sameer Wadhwa swadhwa@...	Jul 6, 2001 1:42 pm
11	Hi, Here is the complete scenario DATABASE 8.1.6.3.0 , NON ARCHIVE MODE OS :- HPUX 9000 1.. I dropped one of my datafile from database by alter database...	Sameer Wadhwa swadhwa@...	Jul 6, 2001 4:36 pm
12	Hi, Status of datafile after drop will always remain available even you drop the datafile with offline drop option. To clear this datafile from tablespace ,...	Sameer Wadhwa samoracle@...	Jul 10, 2001 1:41 pm
13	Hi, I raised TAR to Oracle about this question. BEQ Protocol and trace file is generating because of bug no 1158155. During service registration, PMON sends...	Sameer Wadhwa samoracle@...	Jul 11, 2001 6:35 pm
14	Hi, On Windows 2000 oracle service would n't start automatically after reboot. You have to manually connect to svrmgrl or sysdba to start oracle. I did not...	Sameer Wadhwa swadhwa@...	Jul 11, 2001 6:45 pm
15	... reboot. ... I did ... facing this ... Do you have the services set to start up automatically?...	rscott@...	Jul 11, 2001 8:39 pm
16	Hi , It look that this is bug . refer to doc 66015.996 on metalink title 'Oracle service do not start'. I tried the work around defined in this doc , but all ...	Sameer Wadhwa swadhwa@...	Jul 11, 2001 9:40 pm
17	Here is the doc id from metalink Doc <http://metalink.oracle.com/help/usaeng/Search/search.html#file> ID: Note:135375.1 Subject: Database Autostart Fails...	Sameer Wadhwa swadhwa@...	Jul 11, 2001 9:54 pm
18	It will. But after you login to ORACLE, make sure that you include the instance name you want to use !! ... __________________________________________________ ...	SAMI ICS samiics@...	Jul 12, 2001 6:40 am
19	The problem is solved by putting 8.1.6.3.0 patch and windows 2000 service pack 2 Thanks Sameer ... From: SAMI ICS [mailto:samiics@...] Sent: Thursday,...	Sameer Wadhwa swadhwa@...	Jul 12, 2001 4:21 pm
20	Dear Members, I would like to know clarifications with respect to passing parameters to control files at runtime while using SQL*Loader. For Transaction Date...	Sambasiva Rao sivavaddempudi@...	Jul 16, 2001 12:22 pm
21	Hi Rao, I do n't think so you can put > or < in when clause . Only = and != operators are valid for condition in when clause. May be you have to recreate a...	Sameer Wadhwa swadhwa@...	Jul 16, 2001 2:53 pm
22	hi members, I have seen in a metalink a statement like this SQL> CREATE TABLESPACE local_uniform DATAFILE 2 ...	john reuna dbajohn2001@...	Jul 18, 2001 5:06 pm
23	REUSE simply states that if the file name declared already exist in the file system, oracle is to reuse it. If reuse is not given and the file exists, and...	Rollen, Jerry jerry.rollen@...	Jul 18, 2001 5:10 pm
24	Dear Members Tablespaces are 2 types. one is Dictionary Managed and the other one is Locally managed. The given statment is related to the locally managed...	p k s subrahmanyeswar... bpkssrao@...	Jul 19, 2001 9:49 am
25	HI Memebers, Some oracle export told me that when we load data through sqlloader with direct=Y ,then it loads the data above the High water mark and lots of...	john reuna dbajohn2001@...	Jul 19, 2001 5:26 pm
26	According to Oracle: "When you perform a Direct path parallel load, SQL*Loader creates temporary segments for each concurrent session and then merges the...	Scott, Randy (TIFPC) rscott@...	Jul 19, 2001 5:56 pm
27	... John, Yes, this is true. But it can speed up your loading with SQL*Loader! When records are inserted into a table, a block must be found to hold that ...	Brian Peasland peasland@...	Jul 19, 2001 6:15 pm
28	Thanks scott , it explains a lot ... __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail ...	john reuna dbajohn2001@...	Jul 19, 2001 6:16 pm
29	To avoid wastage of space, it is good to check the HWM before loading bulk data from sql*loader with DIRECT=Y . If you see the high water mark is at high...	Sameer Wadhwa swadhwa@...	Jul 19, 2001 6:30 pm
30	I really did not understand the question . Can u put some more light on this ? Amith Amith Uppal 781-324-9615 (res) 617-241-3600 (ext 120) office . ... Get...	AMITH UPPAL uppal_amith@...	Jul 19, 2001 7:23 pm
31	Hi Amith, The Discussion is when you load the data from SQL*LOADER with direct=Y option . It loads the data above the HWM. So if your table is having lots of ...	Sameer Wadhwa swadhwa@...	Jul 19, 2001 7:44 pm
32	... From: Rajinder Gaur To: SWadhwa@...; anuj_k_gupta@...; gbgupta@...; torontodba@...; muralidhar.janga@...;...	Sameer Wadhwa swadhwa@...	Jul 20, 2001 4:42 am
33	Hi Members, The following is the description of dba_data_files. SVRMGR> desc dba_data_files Column Name Null? Type ... FILE_NAME...	Mariana paulla sahilnov@...	Jul 20, 2001 2:30 pm
34	According to the Oracle 8i Reference Manual, USER_BLOCKS is the number of blocks which can hold data(minus the header info?) and USER_BYTES is the ...	Scott, Randy (TIFPC) rscott@...	Jul 20, 2001 6:01 pm
35	To find out how much space in the data file is occupied we have to do In short A. check for bytes in dba_data_file B. Check for bytes in dba_free_space C. A-B ...	Mariana paulla sahilnov@...	Jul 20, 2001 6:09 pm
36	A standard script that I use is listed below: rem ------------------------------------------------------------- rem Tablespace Usage rem...	Scott, Randy (TIFPC) rscott@...	Jul 20, 2001 6:17 pm
37	So if you want to have exact value you should use USER_BYTES instead of bytes. and substact sum(bytes) from dba_free_space It will give you total amount of...	Sameer Wadhwa swadhwa@...	Jul 20, 2001 6:27 pm
39	That would be correct according to the doucmentation. ... From: Sameer Wadhwa [mailto:swadhwa@...] Sent: Friday, July 20, 2001 1:27 PM To:...	Scott, Randy (TIFPC) rscott@...	Jul 20, 2001 6:32 pm

Yahoo! Groups Tips

Did you know...

Messages

Yahoo! My Yahoo! Mail
	Sign In New User? Sign Up
		Tech - Groups - Help

Yahoo! Groups Tips

Did you know...

Best of Y! Groups

Messages