Tag Info

New answers tagged

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.


0

At least 14 GB. Maybe more if the dump file is compressed. Maybe less if the tables are compressed. A bit more or lot more if there are indexes. Even Data Pump will miscalculate the required space in case of compressed tables. Index data is not stored in the dump file, only index definitions. You can have a 14 GB dump file with 14 GB table data and 0 ...


0

Using a combination of MASTER_ONLY and KEEP_MASTER switches, it's possible to get Data Pump import to do the dependency tracking, calculations, and estimations of sizes that it does at the beginning, create the master table that it uses to track everything, and then stop. You can then examine the master table to see how big the various tables are estimated ...


-1

I'm afraid there is no way how to do that, archivelogs are a must. Best approach is to use approach recomended by the vendor. Datafiles might be inconsistent anytime, Oracle writes changes into blocks even before the transaction is commited. The only place where you can find an information needed to have data consistent is in (archived) redo-logs. Oracle ...


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): ...


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: ...


0

Of course you need to find a way to match the sequence name with the table name, since there's not a connection or constraint enforced by the RDBMS. When you have it, you may use this procedure to reset a sequence value: create or replace procedure proc_reset_sequence ( p_seq_owner in varchar2, p_seq_name in varchar2, p_target_number in number ) AS ...


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 ...


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 ( ...


0

Here's a "single pass" query that will get you the information you're after, but not in the format you wish: you'll get a single row with one column for each pair of buckets (and for each bucket individually). with item_counts as ( select item_id , sum(case when bucket_id = 'A' then 1 else 0 end) is_a , sum(case when bucket_id = 'B' then 1 else 0 end) ...


0

Bad answer, because in your note you say you don't want a join. But, just in case someone wants to use a join: select a.bucket_id, b.bucket_id, count(a.item_id) from mytable as a left outer join mytable as b on b.item_id=a.item_id and b.bucker_id<>a.bucket_id group by a.bucket_id, b.bucket_id order by a.bucket_id, b.bucket_id; (thinking further for ...


0

I'm successfully able to create a scheduler for my MV to refresh every minutes if the status stallness is not FRESH. Here's my solutions : I created a schedules to be used in my scheduler: BEGIN sys.dbms_scheduler.create_schedule( repeat_interval => 'FREQ=MINUTELY', start_date => to_timestamp_tz('2015-06-09 01:41:55 Asia/Jakarta', ...


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.


0

sqlplus user/password as sysdba uses OS authentication by default, and bypasses the username and password check, so as you said, you can provide any password or username. Logging in from SQL Developer requires a remote session. For a remote SYSDBA connection, you need the following: set remote_login_passwordfile to EXCLUSIVE or SHARED, but not NONE create ...


0

The reason for the databa block corruption is that ther was data inserted in the table with nologging in the timespan between the begin of the backup and '01-JUN-2015 02:00:00'. So the information needed to fully restore the datafiles (by applying the archive log) is not contained in the archives log. Mainly there are two possibilities for you: 1) you try ...


0

You can use TO_TIMESTAMP_TZ Function: SELECT TO_TIMESTAMP_TZ('150601172623+0530', 'RRMMDDHH24MISS+TZHTZM'), TO_TIMESTAMP_TZ('150601172041+0530', 'RRMMDDHH24MISS+TZHTZM') FROM dual; 2015-06-01 17:26:23.000000000 +05:30 2015-06-01 17:20:41.000000000 +05:30



Top 50 recent answers are included