Search results for query: *

Karluk, The problem was with the Oracle installation and now it seems to work fine.. Thanks for all ur help...thank u guys!! -Sai

Karluk, I did try running these scripts..now things have gone worser. 1. The script had some errors while executing. 2. Now for every query which I type I get the error ORA01092..like this one.. SQL> startup mount; ORACLE instance started. Total System Global Area 138412032 bytes Fixed...

Mufasa, I will try to follow your steps and will get back to you. -Sai

Karluk, No I did not follow the same steps..infact this time I customized the installation and carefully reviewed each step. -Sai

Karluk, I tried and started from the scratch but ended up with the same error. Any other thoughts? -Sai

Thanks Karluk, Guess thats my only option..lemme see what can be done..Thanks for your help! -Sai

Karluk, This is the result..looks like the loader is missing..wat do I do now? ------------- SQL> select owner, object_name, object_type from all_objects where object_name='ORACLE_LOADER'; select owner, object_name, object_type from all_objects where object_name='ORACLE_LOADER'...

Mufasa, Looks like they support only people with licenses and I am using a downloaded version.So there was nothing I could get out of it! -Sai

Sure..will do so and will get back to you..Thanks for the information. -Sai

Mufasa, Thats interesting..I tried doing it all over again but it gives me the same error. ORA-29829: implementation type does not exist -Sai

Mufasa, It seems to work out sucessfully in a Windows box for me too but screws up with the UNIX implementation. The result in the UNIX m/c is SQL> select * from dummy1; select * from dummy1 * ERROR at line 1: ORA-29829: implementation type does not exist Thanks -Sai

This is the statement for creating the external table. ...................... create table dummy1( "SRCPHNUM" number(10), "SRCNAME" varchar2(20), "SRCLOCATION" varchar2(20), "DESTNPHNUM" number(10), "DESTNAME" varchar2(20), "DESTLOCATION"varchar2(20), "CALLTIME" number(3), "COMMENTS"...

I am trying to use External Tables with Oracle 10g in a unix box. I have created a corresponding directory...all the settings seem to be fine but I keep getting this error for some reason. Here dummy1 is the external table that I have created which needs to contain all the contents from my...

Dave, They also seem to be right! [sai@ma-1 ~]$ echo $ORACLE_HOME $/home/sai/oracle/product/10.2.0/db_1 [sai@ma-1 ~]$ echo $ORACLE_SID hcsdatabase -Sai

I tried installing Oracle 10g on a unix box. My installtion was sucessful but when I try to run sqlplus I get the following error. ________________________ [sai@ma-1 bin]$ ./sqlplus Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to...