CODEWITHSUNDEEP
oracle-databaseoracle11gsqlplus
kreamik
kreamik

Reputation: 627

confusing about oracle when accessing data

First i want to explain what i have done with my oracle, i use oracle XE in my win7x64.

i have 3 file contained 'insert into ..' query ..

file 1.sql is about 3MB in inserted by Oracle SQL Developer
file 2.sql is about 30MB in inserted by Oracle SQL Developer
file 3.sql is about 120MB and cannot be inserted by Oracle SQL Developer so i use SQLPlus (@3.sql)

the problem is, i only see data 1.sql and 2.sql instead data 3.sql when i open my Oracle SQL Developer.
then i only see data 3.sql instead 1.sql and 2.sql when i login from SQL Plus.

what should i do to see my all data inserterd?

i only connect to this XE in my local laptop ..

Need your suggestion :D

== SOLVED ==

i miss commit on both Oracle SQL Developer and SQL Plus
1. commit in Oracle SQL Developer using F11
2. commit in SQL Plus just happening when you type 'exit' or 'quit'

Upvotes: 0

Views: 140

Answers (1)

Frank Schmitt
Frank Schmitt

Reputation: 30775

So you have 3 files containing a bunch of INSERT statements, and imported file1.sql and file2.sql using Oracle SQL Developer and file3.sql using SQL/Plus.

  • What is the output of SQLPlus after running @file3.sql?
  • Did you do a commit in SQLPlus after importing the data?
  • What query did you run in SQL Developer afterwards to check whether file3.sql was imported?

Upvotes: 2

Related Questions