OraTechSupportGroup : Messages : 65-94 of 457

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

65	Anyone got: create tablespace SYSTEM datafile '/oracle/data/dbe/system01.dbf' SIZE 400M AUTOEXTEND ON NEXT 10240K default storage (initial 10K next 10K)...	lavezzi.ivan@...	Aug 1, 2001 2:38 pm
66	The datatype number can have maximum 38 digits , but in Oracle internal representation . So how can I find out whats the maximum number of digits can I...	AMITH UPPAL uppal_amith@...	Aug 1, 2001 9:32 pm
67	What the trace file is saying . Can you send us trace file. Also send the database creation script which run the create database command. ... From:...	Sameer Wadhwa swadhwa@...	Aug 1, 2001 11:07 pm
68	Also check your LD_LIBRARY_PATH it should contain $ORACLE_HOME/lib64 during installation. Hope it will help Sameer ... From: lavezzi.ivan@......	Sameer Wadhwa swadhwa@...	Aug 1, 2001 11:14 pm
69	Hi amith, I think you can store 9999999.... 38 times. Sameer ... From: AMITH UPPAL [mailto:uppal_amith@...] Sent: Wednesday, August 01, 2001 4:10 PM ...	Sameer Wadhwa swadhwa@...	Aug 1, 2001 11:14 pm
70	Any help !!!!! I need to pass Vector from Java to Stored Procedure & i want that , Procedure to be returned Entire Vector after some processing. Thanks John ...	john reuna dbajohn2001@...	Aug 2, 2001 12:45 am
71	I have two identically server (hw, sw, configuration) on the first all has gone ok on the second I got the error. In .login of oracle user in the two server I...	lavezzi.ivan@...	Aug 2, 2001 7:44 am
72	Hi, I have a small doubt . I have defined a bfile directory on the server . My client application is running remotely . How my application will create a file...	Sameer Wadhwa swadhwa@...	Aug 8, 2001 8:06 pm
73	Hi, I have a small doubt . I have defined a bfile directory on the server . My client application is running remotely . How my application will create a file...	Sameer Wadhwa samoracle@...	Aug 8, 2001 8:10 pm
74	Question ! How can I generate a CSV file from Oracle table data ? Amith ... _________________________________________________________________ Get your FREE...	AMITH UPPAL uppal_amith@...	Aug 8, 2001 8:53 pm
75	Hi Amith You can use the following set of commands:- set heading off set pagesize 0 set linesize 80 -- The above parameters should be defined as per your...	Davinder Sandhu dssandhu@...	Aug 8, 2001 9:59 pm
76	How can u we put single quotes instead of commas ? amith ... _________________________________________________________________ Get your FREE download of MSN...	AMITH UPPAL uppal_amith@...	Aug 9, 2001 1:13 am
77	Hi Amith, what kind of fomat you need do you need 'col1','col2',col3' or 'col'col'col3' ... <tablename>; ... data ? ... the ... the ... in the ... ...	Sameer Wadhwa samoracle@...	Aug 9, 2001 6:02 pm
78	Sameer , I got this 'col1','col2','col3' but in doing this i lose the column header because of concatinating the values . ok ...or can we generate something...	AMITH UPPAL uppal_amith@...	Aug 9, 2001 6:19 pm
79	Try with set heading on ... From: AMITH UPPAL [mailto:uppal_amith@...] Sent: Thursday, August 09, 2001 2:18 PM To: OraTechSupportGroup@yahoogroups.com ...	Sameer Wadhwa swadhwa@...	Aug 9, 2001 6:25 pm
80	It seems you don't want CSV (Comma seperated Variable length), you need single quoted output, you can do so by using: select field1 \|\| '''' \|\| field2 \|\| ''''...	Davinder Sandhu dssandhu@...	Aug 10, 2001 3:58 pm
81	The code was a nested FOR loop with explicit ranges, etc like FOR I IN 1..10 LOOP FOR J IN 1..15 LOOP FOR K IN 1..4 LOOP DBMS_OUTPUT.PUT_LINE(I \|\| ' ' \|\| j \|\|...	wmscottm WMSCOTTM@...	Aug 10, 2001 11:15 pm
82	Question on behaif of v_bala ... How to load data for long raw column using SQL*Loader ? For example i have a table like this : Table Name : Image_Details ... ...	Sameer Wadhwa samoracle@...	Aug 15, 2001 3:13 pm
83	I ran into this same problem and discovered that there is no easy way to do this. I chose to write a shell script that loops through a file of the format: ...	Scott, Randy (TIFPC) rscott@...	Aug 15, 2001 3:42 pm
84	problem ! I had my databse on Oracle 8.1.6 . I wanted to migrate it to 8.1.7 . I installed 8.1.7 , started the database , ran catproc and catalog scripts . the...	AMITH UPPAL uppal_amith@...	Aug 21, 2001 10:00 pm
85	Amith, The correct procedure is to run the ORACLE_HOME/rdbms/admin/u08010600.sql script (as SYS) to complete your upgrade. This is an upgrade, not a ...	Brian Peasland peasland@...	Aug 22, 2001 12:37 pm
86	Hello everybody, I have a query about Oracle's Licensing policy. For a HP-UX 10.01 Oracle 7.3.2.3 with a 5 user License, what happens when a 6th user tries to...	Mashruwala Sumedha, IBM Sumedha.Mashruwala@...	Aug 24, 2001 6:01 am
87	I depends on what the init.ora license parameters are set to. Check these. Usually, these default to null unless someone sets them. If they are set, then a...	Scott, Randy (TIFPC) rscott@...	Aug 24, 2001 12:33 pm
88	I have fully agreed what the scott told you . If you did not set the license parameter in the paramter file. Oracle database does not complaint and allows you...	Sameer Wadhwa swadhwa@...	Aug 24, 2001 7:39 pm
89	Hi, This is a question on behailf on Rajesh Kumar how can i compare the data in two tables . my problem is i had created two tables contain ten fields of same ...	Sameer Wadhwa samoracle@...	Aug 26, 2001 2:05 pm
90	Hi Rajesh, I do n't think it is easy to capture duplicate data while copying with out primay kwy unless you write a database trigger or pl/sql to insert the...	john reuna dbajohn2001@...	Aug 26, 2001 2:28 pm
91	Can any one help me. I am inserting large amount of data in various table. I am experiencing a block buffer contention. My tables are patitioned. I have a sga...	john reuna dbajohn2001@...	Aug 30, 2001 4:21 pm
92	Hi everyone, Is there a way to estimate the duration of the rebuild index operation ? In a test environment I had indexes and data in the same tablespace; then...	lavezzi.ivan@...	Sep 5, 2001 10:32 am
93	We could tell you anything, but the truth is that it might be hard to predict. It does take a long time to rebuild 10G of indexes even if you aren't moving...	Katherine Harms kharms@...	Sep 5, 2001 12:52 pm
94	Question ! problem with the index key length ! heres my table script . CREATE TABLE five_min_so_sum 2 ( 3 bucket_start_time DATE NOT NULL, 4...	AMITH UPPAL uppal_amith@...	Sep 24, 2001 8:28 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