Hi Vishaka, NLS_NCHAR_CHARACTERSET is National Character Set. It specifies what languages can be used to name database objects. I recommends to use UTF8 as a...
Sameer Wadhwa
wadhwa_s@...
Oct 1, 2001 4:53 pm
100
I would like to know if i can use connect user/pass or sqlplus user/pass within pl/sql body. Otherwise, Can i make reference to sqlplus from the host command ...
vishakha@...
Oct 4, 2001 1:07 pm
101
dear friends i need your help in the following matter immediately i want to convert a table created in visual foxpro to oracle using sql loader. i had created...
rajesh Kumar n
rajeshnalankal@...
Oct 8, 2001 3:44 pm
102
I need to sort data that looks like this 1,10,100 type of sequence. I need 1,2,3,4,5,6,7,8,9,10,11, ... type of sequence. How can I sort this type of data so...
MMiller@...
Oct 10, 2001 9:32 pm
103
Hi You can write your query as under: (Please change number 20 in lpad function to the field length of apt_nbr column) select st_nbr, st_pre_dir_code, st_name,...
Davinder Sandhu
dssandhu@...
Oct 11, 2001 12:26 am
104
Try like this: select st_nbr, st_pre_dir_code, st_name, apt_nbr from cisif_premise_t where st_nbr like `%4545%' and st_name like `%MISSION%' ORDER BY...
Balasubramanian Renga...
vr_bala@...
Oct 11, 2001 2:38 am
105
Found this in MetaLink (http://metalink.oracle.com/). Should help. I would suggest using the function to find numerics and LPAD numerics with spaces. Then...
scott Leenhouts
scott.leenhouts@...
Oct 11, 2001 11:58 am
106
RDBMS version: 8.1.6.3 OS: IBM AIX 4.3 I'm trying to import two schemas, between two instances, in a single import operation: 1) export with user sys and...
I have imported my database to dump file, but fail too. The dump file cannot be bigger than 2GB+, so u should use pipe to export and import. *************...
JK Yao
jkyf0131@...
Oct 15, 2001 2:15 am
108
HI Expert, I read somewhere that IOT gives best performance on DSS application. I am bit confused now. As DSS has mostly full table scan and OLTP application...
john reuna
dbajohn2001@...
Oct 17, 2001 2:38 pm
109
Does Oracle affected by a seasonal time change in the machine (NT, Unix) on which it runs ? best regards...
IOTs are generally used when most of the columns of the table are part of a single primary key or some other index . And when it comes to DSS application where...
AMITH UPPAL
uppal_amith@...
Oct 18, 2001 1:24 pm
111
Thanks Amith for the answer. so IOT is good for full index scan. I think full index scan is same as full table scan . Is it right ? One more question. Nested...
john reuna
dbajohn2001@...
Oct 18, 2001 5:49 pm
112
Hi all I have a schema in Access and want to convert all its tables into oracle. Please let me know the way I can convert Access tables into oracle tables. I...
Davinder Sandhu
dssandhu@...
Oct 23, 2001 11:18 pm
113
Dear all, whats ORA-24338. Is anybody aware over there. I understand that whenever a fetch is producing zero records set, the driver/Driver-manager is not able...
vish
gvishakha@...
Oct 24, 2001 7:16 am
114
Hi Vishakha, ORA-24338: statement handle not executed Cause: A fetch was attempted before executing a statement handle. Action: Execute a statement and then...
Mashruwala Sumedha, IBM
Sumedha.Mashruwala@...
Oct 24, 2001 7:30 am
115
Try using Oracle Migration Workbench for Microsoft Access. Bye. ... Da: Davinder Sandhu [mailto:dssandhu@...] Inviato: mercoledì 24 ottobre 2001 1.18 ...
Thanks Mashruwala, but i couldnt understand the description of the error. Definately, i am preparing a fetch before execution. Also, the stmt runs thru 250 ...
vish
gvishakha@...
Oct 25, 2001 5:50 am
117
Hello all, I am trying to run SQL*Plus, and it will not open. If I click on the shortcut for it, I get this error: Message file SP1<lang>.msb not found. I...
wyldgynjer@...
Oct 26, 2001 3:27 pm
118
This problem mostly because of wrong path . Check path and correct home. in env tab and universal home selector. ... From: wyldgynjer@......
Sameer Wadhwa
swadhwa@...
Oct 26, 2001 5:45 pm
119
I checked that, but that's not it. I thought that maybe I had installed something that messed it up, cuz it used to work a few weeks ago..but I've not used it...
Hi everybody, I have to make a small demo using oracle. My problem is, when i install tables and stored procedures on the client's machine in oracle anybody ...
You will have a hard time shutting out the DBA if he(she) has DBA privileges. You can shut out others by changing the user password so they can't log in as...
Katherine Harms
kharms@...
Oct 29, 2001 7:30 pm
122
Hi Pals, I am the beginner and asking for help. I have a problem in installing Oracle7 in SCO Open Server 5.04. Why after 80% installing the process stop and...
Hello Katherine, Somehow, I was added to the OraTechSupportGroup. Do you know how I can be removed from it? thanks, Kenny Katherine Harms <kharms@...>...
Kenny Smith
kenny_c_smith@...
Oct 30, 2001 3:25 pm
124
Kenny, Here is what you need to do: To unsubscribe from this group, send an email to: OraTechSupportGroup-unsubscribe@yahoogroups.com Patrick M. Mason Senior...
Mason, Patrick (KEI/S...
pmason@...
Oct 30, 2001 3:27 pm
125
To unsubscribe from this group, send an email to: OraTechSupportGroup-unsubscribe@yahoogroups.com Try this. Good luck. Katherine Harms Kenny Smith ...
Katherine Harms
kharms@...
Oct 30, 2001 6:49 pm
126
im receiving the following error in my alert log file .. please help me to sovle this ORACLE V8.0.5.0.0 running on NT 4 Dump file...
Hello , This is a dump message which occurs if some client session gets hanged due to some reason may by network problem or the problem in the client machine ...
Mashruwala Sumedha, IBM
Sumedha.Mashruwala@...
Nov 1, 2001 4:13 am
128
Hi, I am facing problem with Ora 03113. It will be of great help someone responding out there. The problem definition is : When i try to do single/bulk blob...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
