Unable to connect Rel. 11.5.3. on RHAT Linux Windows 2000 Client

[asci]

 Hello ALL ,,

Installed 11.5.3 on Rhat and everything is up and running , 
able to  ping and tnsping from windows client , but when it
 comes to 
http://myserver:8002/pls/VIS/oraclemypage.home

it's not showing up.. 

All the required services are up and connectivity looks good 
from client to server .. 

Any ideas , check list ..please 

TIA
RK
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: asci
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Generate PK and FK - Script - error

[ASCI]

All,

I was creatinga script for PK and FK 
generation and looks like I am stuck at this point .. 

Problem:
If the table has a primary key with combinaiton of 
colums , my script is not taking all , it's just taking the last position . 

In one case it shows all the column, but in another 
it just takes the last one and I need to take all of them and seperate them with 
','

this is how my script is 

first script (Shows all )

SELECT a.owner, a.table_name, 
a.constraint_name, b.column_name FROM dba_constraints a, 
dba_cons_columnsb WHERE a.constraint_name = 
b.constraint_name AND a.owner = 
b.owner AND a.constraint_type = 
'P' AND a.owner LIKE UPPER ('USER_NAME%')ORDER 
BY a.owner, a.table_name, b.position;


second script (shows only last column)  


SELECT ' Alter table ' || a.owner || 
'.' || a.table_name || ' ADD CONSTRAINT ' || a.constraint_name || ' 
PRIMARY KEY ( ' || b.column_name || ' ) ;' 
 FROM dba_constraints a, 
dba_cons_columnsb WHERE a.constraint_name = 
b.constraint_name AND a.owner = 
b.owner AND a.constraint_type = 
'P' AND a.owner LIKE UPPER ('USER_NAME%')ORDER 
BY a.owner, a.table_name, b.position/


TIA 
Cheers
RK 

Export question - appending date to dmp file

[ASCI]

Hello All,

I am trying to append date to dmp file while 
exporting it , no luck any ideas..

exp userid=user/passwd imp 
file=EXPDATA$DATE.dmp 

(I need to have system date and if possible time 
(TIMESTAMP ) appended to it .)

TIA
Cheers
RK

Re: Export question - appending date to dmp file

[ASCI]

Yes, I agree, but I have a valid reason for doing 
this in this way.. any sugesstions.. 

Ramana 

  - Original Message - 
  From: 
  DENNIS 
  WILLIAMS 
  To: Multiple recipients of list ORACLE-L 
  Sent: Tuesday, December 04, 2001 12:01 
  PM
  Subject: RE: Export question - appending 
  date to dmp file
  RK - The system nicely timestamps the file automatically for 
  you. Isn't thatgood enough? Another idea - on Unix, tar several files and 
  it will keep thesystem timestamps on them.Dennis 
  WilliamsDBALifetouch, Inc.[EMAIL PROTECTED]-Original 
  Message-Sent: Tuesday, December 04, 2001 10:21 AMTo: Multiple 
  recipients of list ORACLE-LHello All,I am trying to append 
  date to dmp file while exporting it , no luck anyideas..exp 
  userid=user/passwd imp file=EXPDATA$DATE.dmp(I need to have 
  system date and if possible time (TIMESTAMP ) appended to 
  it.)TIACheersRK--Please see the official 
  ORACLE-L FAQ: http://www.orafaq.com--Author: DENNIS 
  WILLIAMS INET: [EMAIL PROTECTED]Fat 
  City Network Services -- (858) 538-5051 FAX: (858) 
  538-5051San Diego, California -- 
  Public Internet access / Mailing 
  ListsTo 
  REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT 
  spelling of 'ListGuru') and inthe message BODY, include a line containing: 
  UNSUB ORACLE-L(or the name of mailing list you want to be removed 
  from). You mayalso send the HELP command for other information (like 
  subscribing).

Latest classes12.zip

[ASCI]

Hello All,

Where can I ge the lates classes*.zip file 
?

I was looking all over metalink,technet and other 
oracle site... no luck..

Any help ;;; PLease

Cheers
RK