export to MS access 1

[mstefani]

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 tables that I see look like oracle type tables, none of my data tables. I tried MS odbc and oracle odbc drivers, but get the same result, no data tables. What am I missing?

thanks in advance

Mike

 

[oradba101]

First of all it is not a good idea to import data into the SYSTEM tablespace. This is what I would do:

1. Delete the tables you imported into the SYSTEM tablespace.
2. Create a new tablespace called DATA (or whatever name you choose.
3. Create a new user and make the default tablespace the name of the tablespace you created.
4. Connect to Oracle with the new user account you created.
5. Import your access data into Oracle.
6. When you re-connect to Oracle with the new user name you should be able to see your access data as the new Oracle user will be the 'owner' of the data.

HTH,

Bill Chadbourne

William Chadbourne
Oracle DBA
TCMHS

 

[mstefani]

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 only to be able to convert this data out of oracle to an access data base for a client. The data that I am working on is on my spare server so this will never be a live enviornment.

thanks again,

Mike

 

[oradba101]

Are you doing this from SQL*Plus or are you using Oracle Enterprise Manager? Knowing this will help in determining how to proceed.

Regards,


William Chadbourne
Oracle DBA
TCMHS

 

[mstefani]

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

thanks,

Mike

 

[mstefani]

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