Category: Oracle

NEW: Creating a Table for Exchange With a Partitioned Table

https://docs.oracle.com/database/122/VLDBG/maintenance-partition-tables-indexes.htm#GUID-2DE24EE4-00EB-4D58-A428-8E6CBD7E7F34

E4 2017 is almost one month away!

E4 2017 is almost one month away! I am looking forward to three days of interesting talks. Register here.

SQL Developer: Save a Package (thanks Jeff Smith)

Got this question: Hello @thatjeffsmith ! How I save packege body and packege spec in same archive? #SqlDeveloper — Felipe Pereira (@FelipeR_Pereira) April 27, 2017 Answer: YES. Make sure you select BOTH. Then set your file type. .SQL as requested Now to confirm I’m really getting what I want. Yes, that. SQL Developer will automatically… via ...

Interesting Post by Jonathan Lewis

The opt_estimate hint is one of many that shouldn’t be used in end-user code and isn’t officially documented. Nevertheless – like so many other hints – it’s a hint that is hard to ignore when you see it floating around the code generated by the Oracle software. This note is prompted by a twitter question […] ...

Using @SQLcl (to be updated)

Taking the new command line tool @SQLcl for a first test drive.Plus Points- installation super-easy- a lot of commands interchangeable with SQL Developer- connectivity via TNS is easy to setup. TIP: if you do not have TNS_ADMIN environment variable in place, run show tnsin SQL Developer in order to get the location for the tnsnames.ora ...

Oracle Live SQL Tool

https://livesql.oracle.com/apex/f?p=590:1000:100225800561367

Oracle Extended Statistics

Introduced 11gR1 and based on virtual columns. Allows better selectivity.Condition has the be equality or IN-lists.We should use them when we have issues by an order of magnitude on the cardinality.Types: Column Group: Have to be from same table. Max 32 Expression: CBO does not know how an applied function impacts the cardinality of a ...

Oracle In-Memory Advisor

Oracle In-Memory Advisor availableFirst released in feb. 2015. Improved version released in July 2015: an updated version of the Database In-Memory Advisor is now available, more information My Oracle Support (MOS) note 1965343.1

SQL Developer Language Settings

Change Oracle SQL Developer language Occasionally, I have to work on Customer environments where the language is set to something non-ENGLISH. Here is how to quickly change that unwanted setting on SQL Developer setting: close SQL Developer edit the file sqldeveloper.conf found at location sqldeveloperbin by adding the option AddVMOption -Duser.language=en restart SQL Developer and ...

Change Account Status

How to change the account status of an EXPIRED account (without knowing the account's password)Requirement: SYSTEM or SYS access1. Identify the value of the passwordselect name,password from SYS.USER$ where name=‘USERNAME’;2. Change the account status by using same password:alter user USERNAME identified by values '< password retrieved above >';

%d bloggers like this: