Blog: Andrew Reid


208 blogs updated: 73 min. ago
How Many Profiles Can an Oracle Database Have?
When you create a database, Oracle gives you one profile, called DEFAULT. You can then create more profiles if you need them. I wondered if ...
0
23-06-2017 23:52:29 Andrew Reid Oracle
Datapump Does not Export Permissions on Objects Owned by SYS
I was reminded recently that Datapump does not export permissions on objects owned by SYS so I decided to write a post about it for my blog....
4
25-09-2016 00:30:30 Andrew Reid Oracle
Deferred Segment Creation not Supported for Partitioned Tables in Oracle 11.2.0.1
I tried to create a partitioned table with deferred segment creation in an Oracle 11.2.0.1 database. First I tried to do so explicitly but t...
0
04-09-2016 22:49:39 Andrew Reid Oracle
How to Automatically Trace a User's Sessions
This post shows how you can use a logon trigger to automatically trace all sessions for a given user. This can be useful where an applicatio...
0
04-09-2016 00:06:36 Andrew Reid Oracle
SUBSTR Versus LIKE in Oracle 11.2
I was reading an old SQL tuning book which was printed in 2002. It said that a where clause with like could often use an index whereas a sim...
0
24-08-2016 20:44:29 Andrew Reid Oracle
Making a Hot Backup and Doing an Incomplete Recovery
This post shows how to do a hot backup followed by an incomplete recovery. I ran it on an Oracle 11.2.0.4 test database. First I checked tha...
4
10-08-2016 23:49:53 Andrew Reid Oracle
ORA-39710 and ORA-00704
I tried to use dbua to upgrade a database from Oracle 11.2.0.4 to Oracle 12.1.0.2. Part way through, my PC lost connection with the UNIX ser...
0
19-07-2016 01:29:01 Andrew Reid Oracle
ARCHIVE_LAG_TARGET on Oracle 11.2.0.4
I read about this parameter, which is supposed to force a redo log switch after a certain number of seconds. I decided to try it out in an O...
0
08-06-2016 00:04:16 Andrew Reid Oracle
ORA-01109
I read that you cannot take a tablespace offline if the database is only mounted so I decided to test this in an Oracle 11.2.0.4 database. I...
0
02-06-2016 22:41:12 Andrew Reid Oracle
How to See When an Oracle Role Was Created
You can get the date and time a role was created from the CTIME column in SYS.USER$. You can see what I mean in the example below, which I t...
0
31-05-2016 00:44:52 Andrew Reid Oracle


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.