Search results for query: *

I have three tables Table 1 -------- key1 value ----------- 1 FALSE 2 FALSE 3 FALSE Table 2 -------- key1 key2 value ------------------ 1 A (null) 1 B (null) 1 C (null) 2 A (null) Table 3 -------- key2 value A 90 B 29 C 11...

marcs41, That is very good information. Thanks If I create a new swap file on D: and reduce the size on C will it release the space on C:?

I am running someone else's sql loader scripts temporarily. I am getting the following message after 15 rows in the log file every time I load the data "Commit point reached - logical record count n" where n is 15,30,......... I am not getting such messages when I run my sql loader...

Here's what I came up with. Is there better efficient and elegant code out there? Thanks ---------------------------------------------------------- TYPE testCur IS REF CURSOR; cur testCur; stmt_str VARCHAR2(200); testrecord table%ROWTYPE; v_record varchar2(2000); prev_index varchar2(25); BEGIN...

Robbie is right. I've got anywhere from 1 to 11 records per index.

Yes I knew it. But just wanted to make sure that I did not miss anything. Thanks

Is there someway I can turn the following data Index Column1 Column2 ----- ------- ------- 1 A B 1 C D into Index Column 1 ABCD The self join gives a cartesian product. Thanks

It worked. Thanks. It took a while the drop the datafile (about 7GB) using alter database command.

The temp tablespace was using all the volume in the diskspace which included the system tablespace. So the physical temp file was deleted. There was not enough disk space to created another temp file,drop the old one and bring back the new one back up

Is there a way to bring the database up without the temporary tablespace by specifying some initialization parameters.

I have a sequence used by multiple users. Some users want to generate blocks of continous sequential numbers at a time. I believe I can generate these numbers with a loop statement. I was wondering if the sequences can be locked when someone is accessing it so they can get the block of data they...

How do I pass substitution variables to sqlplus script through a shell script? Thanks

carp, Thanks for your response. I tried using utl_smtp package and I was getting this error message ORA-29540: class oracle/plsql/net/TCPConnection does not exist Here is the code procedure send_mail( p_sender IN VARCHAR2 DEFAULT 'my address', p_recipient IN VARCHAR2...

Is it possible to run SQLPlus commands from a PL/SQL package/procedure? I need to send mail using unix mail utility. I intend to do this by using the SQLPlus' host' command. OR Is there any other oracle utility to send mail? I have a...