Dear Friends We want to drop the USERDAT2 tablespace but this tablespace is having the following objects and OWNER is SYSTEM. These objects are not at all...
myvisaka
subrahmanyam@...
Apr 2, 2002 9:32 am
208
Hi, I need your urgent help. How do i get over this kinda error " Fail to Conver between UTF8 and UCS2" while using JDBC (JDK 1.3 and classes12.zip) My db is...
vish
gvishakha@...
Apr 8, 2002 12:10 pm
209
Hi I have installed oracle (english) on win2000 platform and my enviroment is german and I don't have your problem ,my developing tools is Jbuilder that...
Hello Friends...I am using one .dat file that contains several values in a particular column and I need to load those values in different Oracle tables when...
starfs4000
J_90000@...
Apr 13, 2002 8:21 pm
211
Hi, I have a column having datatype clob. I tried to load data to this coulmn. But I get "ORA-01704 string literal too long". I check Oracle web site and...
Hi, I have a column having datatype CLOB. I tried to load data to that column and get the error message which is "ORA-01704 string literal too long". Ichecked...
Hi all, Please subscribe to the group Oracle freshers at Oracle_freshers-subscribe@yahoogroups.com. It's a group for freshers in Oracle. The intention is to...
... From: nayan_p7 [mailto:nayan_p7@...] Sent: Wednesday, April 17, 2002 10:01 AM To: OraTechSupportGroup@yahoogroups.com Subject: [OraTechSupportGroup]...
Ramesh Prashanth
ramesh@...
Apr 17, 2002 6:19 am
215
Hello everybody, Here is a group for freshers who want to make a career in Oracle Products. The intention is to give freshres a chance for a good job openings....
Hi I want to disconnect the desired users with in a specific range of time. How do i do that ? For example i do not want to allow user say x to connect to the ...
Put the database in restricted mode. Alter system enable restricted session; Only users with either dba privileges or that have been granted "restricted ...
This will not solve the problem as requirement is to disallow a specfic user for a specfic timings and allow others to work without DBA intervention. ... From:...
Sameer Wadhwa
swadhwa@...
Apr 24, 2002 7:23 pm
219
Hello , Please change my address from auppal@... to uppal_amith@... AMITH ... From: Varughese M To: OraTechSupportGroup@yahoogroups.com Sent:...
Amith Uppal
uppal_amith@...
Apr 24, 2002 9:59 pm
220
Hi, One crude way that I can think of is to have a table with the scheduling details and the usernames. Use a on database logon trigger and within the body of...
Sudheendra Vijaykumar
sudhi76@...
Apr 25, 2002 9:36 am
221
Hi all! I'm trying to install 8i on RedHat Linux 7.0. I've tried everything (that I could find on the internet), but have not been successful. I even...
1. Check which version of glibc u have on ur system? rpm -qa | grep libc 2.install the following 3 RPM's compat-glibc-6.2-2.1.3.2.i386.rpm ...
vish
gvishakha@...
May 3, 2002 5:51 am
223
Dear Friends Alter table <table_name> Move tablespace <tablespace_name>; Using this command, moved all tables to another tablespace except one which is having...
p k s subrahmanyeswar...
bpkssrao@...
May 3, 2002 11:31 am
224
Create the following procedure: procedure move_tablespace ( p_table_name varchar2, p_tablespace_name varchar2, p_index_tablespace varchar2 default...
Thanks, Vishakha, for your response. Actually, I got the database creation to work after I posted my "mayday" on this group. I went back to the installation...
If you don't want the table / data use the following command. DROP TABALESPACE <tablespace_name> INCLUDING CONTENTS; Suppose you want to drop the tablespace...
Ramesh Prashanth
ramesh@...
May 6, 2002 5:33 am
228
hi dear, May be this will help you: http://www.palslib.com/Oracle/Installation.html hths Vishakha ... ...
vish
gvishakha@...
May 6, 2002 7:04 am
229
Thanks, Vishakha, but I don't need it anymore. Like I described in http://groups.yahoo.com/group/OraTechSupportGroup/message/225 , I've installed Oracle 8i on...
Limitations of the "ALTER TABLE MOVE" Command: * Supported only in Oracle 8.1.5 and higher * Does not support directly some objects and some data types: *...
Ramesh Prashanth
ramesh@...
May 9, 2002 2:41 pm
231
Hi, I came accross a set for Oracle8i paper 1Z0-001. If any body want its sample set you can contact vaikunthus@.... They are giving few questions for...
How to drop multiple column from the table. I tried the following syntax but it did not work ALTER TABLE <TABLE NAME> DROP COLUMN (<COLUMN1>,<COLUMN2>); I am...
Oracle does't support dropping multiple columns. It is not a bug. But you can overwrite using the following procedure my_drop. /* Created by Balasubramanian.R ...
Hi Oracle provide us this functionality Or9i SamSQL>desc emptab Name Null? Type ... EMPID...
Sameer Wadhwa
swadhwa@...
May 28, 2002 6:06 pm
235
hi, I am getting one EOF communication error. In the following query when i comment out "AND v1.categoryId =63089" the query runs but uncommenting fires ...
vishakha@...
May 30, 2002 10:42 am
236
Are you using index with desc option ? ... Da: vishakha@... [mailto:vishakha@...] Inviato: giovedě 30 maggio 2002 14.06 A:...
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.
