OraFAQ Forum: Server Utilities » Export from ms access 2007 to oracle

Home » RDBMS Server » Server Utilities » Export from ms access 2007 to oracle (Oracle 10 g express edition)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export from ms access 2007 to oracle [message #414679]

Thu, 23 July 2009 03:20

NewToOracle10g
Messages: 34
Registered: April 2009
Location: Adelaide

Member

Hi

I'm exporting access db to oracle 10g using access export tool.
In orcale object browser i'm able to table created with data. But if i run any command in sql prompt i get error as table or view not found.

What is solution for this?

Regards,
Leena

Report message to a moderator

Re: Export from ms access 2007 to oracle [message #414681 is a reply to message #414679]

Thu, 23 July 2009 03:46

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Could you give some more information, such as: what is "orcale (Oracle?) object browser" which makes tables and data visible, what "sql prompt" you are talking about, which schema you are connected to, etc.

Copy-paste of your SQL*Plus session (or screenshots if necessary) would be better than explaining all this in words.

Report message to a moderator

Re: Export from ms access 2007 to oracle [message #414687 is a reply to message #414679]

Thu, 23 July 2009 03:50

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Copy and paste what you did, do not (try to) explain it.

Regards
Michel

Report message to a moderator

Re: Export from ms access 2007 to oracle [message #414689 is a reply to message #414681]

Thu, 23 July 2009 03:50

NewToOracle10g
Messages: 34
Registered: April 2009
Location: Adelaide

Member

i'm using Orcale 10g. it provides web based object browser. In that i can see table. But when I write any command such as select * from table in sql plus window or sql command line(as it is called in 10g express edition) i get error as table does not exists.

Report message to a moderator

Re: Export from ms access 2007 to oracle [message #414695 is a reply to message #414689]

Thu, 23 July 2009 04:00

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This does not help much.

reported message

Reported By: NewToOracle10g On: Thu, 23 July 2009 10:55 In: RDBMS Server » Server Utilities » Export from ms access 2007 to oracle
Reason Many times I have noticed that replies by Michel Cadot are very rude. I'm posting in this forum because I do not know oracle 10g well and i hope that some expert might help me understanding it better.

I'm only hard with those that do not read the OraFAQ Forum Guide.

Regards
Michel

[Updated on: Thu, 23 July 2009 04:00]

Report message to a moderator

Re: Export from ms access 2007 to oracle [message #414696 is a reply to message #414689]

Thu, 23 July 2009 04:02

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Reported message

Reported By: NewToOracle10g On: Thu, 23 July 2009 10:55 In: RDBMS Server » Server Utilities » Export from ms access 2007 to oracle
Reason: Many times I have noticed that replies by Michel Cadot are very rude. I'm posting in this forum because I do not know oracle 10g well and i hope that some expert might help me understanding it better.

The fact is: it is hard to believe that tables and data are there now, but a second later they disappear. That's why Michel (and me, using almost exactly same words) have asked you to provide additional information. Otherwise, it is difficult to help.

In my opinion, your report was unnecessary.

Report message to a moderator

Re: Export from ms access 2007 to oracle [message #414703 is a reply to message #414696]

Thu, 23 July 2009 04:11

NewToOracle10g
Messages: 34
Registered: April 2009
Location: Adelaide

Member

I'm not trying to explain what i did but it is difficult to exactly copy paste what i did in forum post. I understand that maybe from my description it was difficult to understand the problem but there are better ways to say this.
I have been actively participating in other forums also. But I have never recieved such rude reply.
I do not wish to talk more on this and i'll get back to problem.
I have posted screenshots on flickr. This is the link.
http://www.flickr.com/photos/40036203@N04/3748216831/

Report message to a moderator

Re: Export from ms access 2007 to oracle [message #414714 is a reply to message #414703]

Thu, 23 July 2009 04:55

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you connect to the same schema when in your GUI and SQL*Plus?

What is the result of

select * from tab;

run at the SQL*Plus prompt?

Report message to a moderator

Re: Export from ms access 2007 to oracle [message #414715 is a reply to message #414714]

Thu, 23 July 2009 04:57

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Ouch, right ... perhaps I've found what the problem is.

GUI suggests that table name is"copy_PLIB_CATALOG". You are querying "copy_plib_catalog".

Is it possible that you (someone?) has created a table using mixed case? As long as it might work fine in MS Access, Oracle doesn't like mixed case. Therefore, try with

select * from "copy_PLIB_CATALOG";

in SQL*Plus - exactly as I've typed it, using double quotes.

Report message to a moderator

Re: Export from ms access 2007 to oracle [message #414734 is a reply to message #414715]

Thu, 23 July 2009 05:49

NewToOracle10g
Messages: 34
Registered: April 2009
Location: Adelaide

Member

bingo...
that was the problem....
select * from "copy_PLIB_CATALOG";
worked....
thanks... i was not aware that mixed case object name create problem in oracle...

Report message to a moderator

Re: Export from ms access 2007 to oracle [message #414737 is a reply to message #414734]

Thu, 23 July 2009 06:03

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Do you now understand why copy-paste helps tremendously? Such a request is not because someone wants to be rude; finally, it is you who needs help. People will provide it if there's enough quality information.

As one/some of our members likes to point out: those who live by the GUI, die by the GUI. If you did it all in SQL*Plus, everything would be much more clear in the first place.

OK then, good luck with Oracle (till your next problem Smile

Report message to a moderator

Re: Export from ms access 2007 to oracle [message #414797 is a reply to message #414737]

Thu, 23 July 2009 09:01

NewToOracle10g
Messages: 34
Registered: April 2009
Location: Adelaide

Member

i misunderstood Michel' post.. ...
(copy paste was supposed to be only for sql command Confused

)

I apologize to Michel.

Report message to a moderator

Previous Topic:	migrate to 9i from 10g
Next Topic:	Import takes long time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 07:40:07 CST 2025