Search results for query: *

thanks lewis and VC, It works now !!!. I'll have to do the other tables the same way. thanks again.

thanks for replying VC, I tried the grant feature below. I connected to SCOTT, GRANTED select to the bonus table to STUDENT. Then I connected to STUDENT to try to select something from the bonus table, it still gives the 'table does not exist'. Since the BONUS table is NOT in the STUDENT...

lewisp, I tried that with the BONUS table, but received an error message. The BONUS table is under the SCOTT user database. So I connected to STUDENT database and keyed in the below (create table bonus as select * from scott.bonus;). CREATE TABLE bonus AS SELECT * FROM scott.bonus...

how do I copy a table from one user to another, without rekeying all the data ? I'm studying Oracle 9i; attempting to get practice using select/single-row/group functs/date functions, joins and sub-queries, etc. But some of the tables are under USER: student Others are under USER: scott Is...

Does anyone know of a VERY beginner level book (or ONLINE site) which would contain only (or mostly) SQL exercises; including answers ? I just started an E-Commerce class which is teaching Oracle 9i, then JAVA/XML/HTML, then the next session will be Oracle Database Administration. I'm only 2...

I'm loading O-9i on my Pent4(Win XP Home) (didn't get the linux yet). The disks are from my instructor(burned CDs) and total 4. On the third DISK the message for the "Oracle Universal Installer: File Locations" section appeared the below error popup box: E:\Stage\Products.jar not...

THANK you sybase.. for the encouragement. I do not have broadband yet(currentlly use isp dial up)...but high speed cable- should be available in my area by the end of July, I'm told by Cable company. I will DEFINITELY pursue the LINUX option...thanks again. Sam

Thanks sybaseguru, I've been told that LINUX taks up LOTS of space on PCs...would the 80Gb hardrive and the 512 MB been enough for both ORACLE 9I AND LINUX ? Also that LINUX is hard to configure. I've never even installed anything on a computer before. All my work with PCs has been at my...

Thanks Turkbear, the PC is a Pent-4,512mb/533 bus/2.26GB freq. 80 GB Hdrive. I'll be attempting this after class tonight. Sam

all, I'm taking an Oracle class & have purchased a computer to install the Oracle 91 to do class work and learn the system. The OS is Windows XP Home. Can Oracle 9i be installed with the XP HOME already installed ? I have purchased Windows 2000 Professional UPGRADE.(never opened, still in...