oracle 817 won't start...
Hi All, I'm experimenting with oracle 817 on a w2k box. It was running fine, but this morning it refused to start. When I tried to log onto the oracle server, I got the following error message: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist I searched the web for a solution and tried a few things including using ORADIM to auto start the oracle server, but nothing seemed to work. As far as I know, there's no system change since I started it last time and all oracle related services appeared to be running. Any idea what the problem could be? Thanks a lot. WL __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lwm 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).
move schema away from system table space
Hi All, I need to move a user/schema away from the system tablespace to a newly created user tablespace. Could somebody point me to the references on how to do the job? Since a production server is running off the schema, is it possible to do the move without having to shut down the server? Thanks a lot. WL __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lwm 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).
dynamic sql questions
Actually, two questions here: 1. I have a dynamicly-built query that will be executed using dynamic sql: select Z, (select y from tableA t1 where t1.id=t2.id) X from tableA t2; To get the value from the query, I use: dbms_sql.column_value( theCursor, 1,columnValue); dbms_sql.column_value( theCursor, 2,columnValue); Now, how can I get the column name (i.e. X) using dynamic sql? 2. I tried to use a group function in the above query as following: select countZ) A, (select y from tableA t1 where t1.id=t2.id) X from tableA t2 group by X; The query failed and the error message was: ORA-00904: invalid column name (i.e. Oracle says that X is not a valid column name) Is ther a way to work around this problem? Thanks a lot. WL __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lwm 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).