Tag Info

Hot answers tagged

4

As an academic exercise, I've implemented a solution in Postgres. Now, I know this was a question about Oracle, but it was also framed as a SQL question! :) If someone is more familiar with Oracle's recursive query syntax, maybe they can find the necessary changes to make this run in Oracle. Recursive Querying (in Postgres) In this solution, I make use ...


4

The following works but there's probably some more clever version. Explanation of the query's logic: We first find how many "resets" have been done up to and including the current row by counting the not nulls of the reset_val column, so we can separate the rows into subgroups. We also use another window function LAST_VALUE() with IGNORE NULLS, so we can ...


2

This version of Oracle XE is based on 11g2 edition, which is not compatible with CentOS 7. In fact, it isn't even 100% compatible with CentOS 6, however it will run there without problems, after you install a number of RPM packages not installed/required by Oracle installer (especially libaio both 32/64-bit). These are formal OS requirements for XE 11g2: ...


2

No. This is not possible. There are various options that might help you recover from this situation or even prevent it from happening in the first place though. Think about it like this: how do you determine when the "data gets corrupted"? Imagine that you could decode and scan through the archived redo logs, before they get shipped to the standby. How ...


2

Choose Install database software only, then later you can upgrade your databases one by one with DBUA (Database Upgrade Assistant) from the new Oracle Home, or by performing a manual upgrade.


1

If the problem is only cannot start sqlplus, there are two alternatives: 1) If one has the GUI (GNOME or KDE), do the search: "sql command line", and It will appear Run SQL Command Line. 2) Check again the environment variables. Edit the files /root/.bash_profile and /root/.bashrc (for example: # nano /root/.bash_profile) and put the line (at the end): ...


1

First, we need to get a list of all buckets. if you already have a table buckets with all bucket_id (as PK), this part is not needed: with buckets (bucket_id) as ( select distinct bucket_id from table_x ) , Then we get all bucket couples and the count of their common items - through a self-join: couples (bucket_a, bucket_b, cnt) as ( ...


1

No, Oracle does not take advantage of that security policy and always zeroes out the files before writing to them. I have no idea whether ASM behaves in a different way, but in the filesystem files are always initialized.



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