Search results for query: *

Bill, I figured out how to add a tablespace and user with dba priviledges and it worked. I can now see it in Access!! thanks a million Mike

Hi, I have both and am very familiar with sql but I like interface of enterprise manager. thanks, Mike

Thanks Bill, I am new to Oracle, MSSql is my thing, so I don't know how to create a tablespace and when I've tried to create a new user, I never know how to give it the proper rights. Can you assist with the details of how to do what you recommended? As a little background, I am doing this...

Hi everyone, Thanks to impressive input from Karluk and you all, I have taken an oracle 7.3.4 db and imported into 9i personal edition into the "system" table space (if I used that term correctly). I can log into sql as system and see the data. I set up odbc to link to MS access, but the only...

Do I have a priviledges problem to those tables? what command do I need to use to grant access to everything for that system user? Do I do it through SQL and which user do I log into SQL as? thanks, Mike

That worked Karluk, thanks again. the import showed all of the tables being imported and I can see them using SQL. But as usual I still have an issue, the odbc still only sees the system tables. the imported tables that I see in sql are not visible using odbc. Any more help would be greatly...

Hi, thanks again for the input. I am using the 9i import utility since I could never find the cds for 7.3.4. The data is on the 7.3.4 server now so the export is using that utility. Maybe a better/easier course would be to odbc to the existing 7.3.4 NT server. Do I need to load the 7.3.4...

Hey, that worked. thanks Karluk. I have one other small problem. when I restored the 7.3.4 dump to 9i it would not restore and said that it was skipping tables. so I modified my imp to include fromuser touser both set to system and then there were no more errors and it completed. The...

Hi Dave, I am an IT consulant in Los Angeles. I have a new client that is moving off of an accounting program that runs on Oracle. The current IT has never upgraded them and really, the system was static and didn't need to be upgraded. The problem is that now they want to go to a new...

Also in the same boat, can anyone get me a copy of the oracle 7.3.4 cd for win NT? I am new to this forum so I don't know how you contact me without posting my email address, I will keep checking the forum. Thanks, Mike