Home » RDBMS Server » Server Utilities » Export from ms access 2007 to oracle (Oracle 10 g express edition)
Export from ms access 2007 to oracle [message #414679] Thu, 23 July 2009 03:20 Go to next message
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
Re: Export from ms access 2007 to oracle [message #414681 is a reply to message #414679] Thu, 23 July 2009 03:46 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: Export from ms access 2007 to oracle [message #414687 is a reply to message #414679] Thu, 23 July 2009 03:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste what you did, do not (try to) explain it.

Regards
Michel
Re: Export from ms access 2007 to oracle [message #414689 is a reply to message #414681] Thu, 23 July 2009 03:50 Go to previous messageGo to next message
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.
Re: Export from ms access 2007 to oracle [message #414695 is a reply to message #414689] Thu, 23 July 2009 04:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: Export from ms access 2007 to oracle [message #414703 is a reply to message #414696] Thu, 23 July 2009 04:11 Go to previous messageGo to next message
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/
Re: Export from ms access 2007 to oracle [message #414714 is a reply to message #414703] Thu, 23 July 2009 04:55 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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?
Re: Export from ms access 2007 to oracle [message #414715 is a reply to message #414714] Thu, 23 July 2009 04:57 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: Export from ms access 2007 to oracle [message #414734 is a reply to message #414715] Thu, 23 July 2009 05:49 Go to previous messageGo to next message
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...
Re: Export from ms access 2007 to oracle [message #414737 is a reply to message #414734] Thu, 23 July 2009 06:03 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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).
Re: Export from ms access 2007 to oracle [message #414797 is a reply to message #414737] Thu, 23 July 2009 09:01 Go to previous message
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.
Previous Topic: migrate to 9i from 10g
Next Topic: Import takes long time
Goto Forum:
  


Current Time: Sun Dec 11 08:29:22 CST 2016

Total time taken to generate the page: 0.08314 seconds