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
95
HI amith, How are U ? This error is signalled because the combined lengths of the columns specified + overhead exceed the maximum key length for the target...
Sameer Wadhwa
swadhwa@...
Sep 25, 2001 2:34 am
96
Hi, I have some queries. 1> I have created my oracle database in UTF8 charset and ncharset is set to US7ASCII. Could anyone please let me know what settings...
vishakha
vishakha@...
Sep 25, 2001 5:58 am
97
According to the Oracle documentation below, you have exceeded the maximum index_width for your operating system. Cause: The combined length of all the columns...
Katherine Harms
kharms@...
Sep 26, 2001 5:35 am
98
Hi Guys, I am working on linux(Oracle 8.1.6) and solaris(oracle 8.1.5). My database set is set to UTF8 charset and nls_lang is set to AMERICAN I am able to...
vishakha
vishakha@...
Sep 26, 2001 6:17 am
99
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...
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.
