Tag Info

Hot answers tagged

3

Use this one: DROP INDEX SYSTEM."IX_isbn_send_h.D_STAT"; Note, when you use quotes, then names are case-sensitive in Oracle.


2

As it was started by Andreas it will not compress the data. Also this online compression is extra cost option. And moreover usually online compression has worse compression ratio, then offline one. It because the 1st one work on row level while the latter one works on block level. So if you really want to spare some space in the database and your old data ...


2

Yes! This is called a 10053 trace in Oracle parlance. It's more formally known as "Tracing of Optimizer Computations". Check out MOS doc 225598.1, or Jonathon Lewis' blog post here: https://jonathanlewis.wordpress.com/2014/05/23/10053-trace/ There's loads of hits for "10053 trace" so if you can't find what you need, it's probably out there in search-land. ...


2

There is absolutely nothing about this on the Internet - even the Oracle docs regarding the %_ASSEMBLIES views don't actually state what they show. However, if you go digging around in $ORACLE_HOME/rdbms/admin you'll see the following reference to the data dictionary views (which sit on assembly$: remark remark FAMILY "ASSEMBLIES" remark remark Views for ...


2

Sounds like a data pump using a network link would do the job. It's always preferable to run it during quieter hours but if your source database is not under powered then you might be able to run it during regular hours without your user's noticing any difference in performance. From the article create a database link from the destination to the source ...


1

This is not going to work. Oracle binaries of a certain version correlates to the Oracle Database dictionary of the same version. RMAN is a backup and recovery tool. It is NOT an upgrade tool. You need to restore and recover you database on 11g binaries. From there you can upgrade your database to 12c. You can have many versions of Oracle Database ...


1

The question would have been a better candidate for stackoverflow. Anyways, the problem with your SQL is that the GROUP BY should only be on the author name and not on author name + book title. From the GROUP BY on author name, get the max(number_of_pages) and wrap it inside another SELECT to to get the books by that author that have that those number of ...



Only top voted, non community-wiki answers of a minimum length are eligible