Tag Info

New answers tagged


It seems that the video tutorial missed a grant, the correct command is the following: GRANT CONNECT, RESOURCE, CREATE SESSION, CREATE VIEW, CREATE MATERIALIZED VIEW TO migration_repo IDENTIFIED BY migration_repo; The database must also have the USERS tablespace. I found the previous information in this thread.


There is no such thing enabled by default in the database. V$ or DBA_HIST views are not guaranteed to contain all your SQL statements all the time. The amount of memory to store SQL statements in V$ views is limited, and DBA_HIST views contain only sampled data. Furthermore, they do not store information about constraint violation errors. If you want to ...


The data you require is exposed by the view v$sql. You can narrow down the statement you're looking for by filtering on the SQL_TEXT column. Documentation link. If you have a diagnostics pack license, you can use the DBA_HIST_SQLTEXT view - it keeps snapshots of SQL statements that may have aged out of v$sql.


for SQL developer (not sure about PL/SQL Developer), the way to see your output is through Output Variables log view. If you go to View->Log (Ctrl-Shift-L) that is where sql developer puts the results. To make it conducive to sql developer, I would recommend using the following execution method: DECLARE CV_RESULTS sys_refcursor; BEGIN SP_EMP( ...


I forgot the most obvious thing: session parameters can be changed! I had this on the latest revision: ALTER SESSION SET NLS_LENGTH_SEMANTICS = 'CHAR'; ... but not the older one. I was running the scripts in a different session thus I couldn't spot the value change.


You have to use Service Names to connect to Pluggable Databases in 12c. It's just one of those things that can trip you up, I guess! SQL Plus connecting OK probably threw you.


If you are done with all above solutions, Please run Sqldeveloper as "Run As administrator" and test Imran Barolia


SQL Developer doesn't include a database. Your connection is asking to connect to Oracle Express Edition, XE - which you would have to download and install separately. I talk about this here.


I would not touch that directory, I have not found any references of other users using the SQL Developer software that comes with database binaries. Additionally, SQL Developer shipped with the database binaries is kind of outdated. Even comes with SQL Developer 3.2 I would just perform a seperate install. Also, I find it unusual that someone, who ...


In SQL Developer you can try this technique: /*sqldev:stmt*/begin transaction; INSERT ... update ... /*sqldev:stmt*/rollback; See: http://stackoverflow.com/questions/17826779/disable-autocommit-in-sql-developer-when-using-mysql

Top 50 recent answers are included