Solved

Oracle SQL Developer tool and data import

Posted on 2013-01-09
3
559 Views
Last Modified: 2013-01-09
I have an Oracle database on UNIX with Table1 and Table2 created by user1. I have connected to that database via SQL Developer and imported data into Table1 and Table2 from different csv files. When I run select statement on SQL Seveloper on either table, it shows correct data. But when I attempt to run a query from SQL Plus on another computer, my selects do not return any records. Why is this happening?
0
Comment
Question by:YZlat
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 38760007
Did you commit the records from inside SQL Developer?  If not, then only the session that inserted them can see them.
0
 
LVL 35

Author Comment

by:YZlat
ID: 38760039
I tried executing commit;
0
 
LVL 35

Author Comment

by:YZlat
ID: 38760045
Oh, I didn't check the select statements after executing commit; statement:)
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Attention: This article will no longer be maintained. If you have any questions, please feel free to mail me. jgh@FreeBSD.org Please see http://www.freebsd.org/doc/en_US.ISO8859-1/articles/freebsd-update-server/ for the updated article. It is avail…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question