Tag Info

Hot answers tagged

6

Have you seen this? https://community.oracle.com/thread/889338?start=0&tstart=0 It states you can only exchange partitions from a partitioned table to a non-partitioned table, or vice-versa. You'd need to temporarily exchange the partition into an interim, non-partitioned, table, then into the target partitioned table. There are some interesting ...


3

This answer is wrong, because the value for rownum is assigned before the order by is executed. Below is the correct one, SELECT start_date, end_date, resort_id, ROWNUM FROM (SELECT start_date, end_date, resort_id FROM employee_activity WHERE employee_id = 27 ...


3

This is really a Unix/Linux question, but it does relate to Oracle, so I'll give an answer. In Unix, the system makes great use of what it calls "spawning" (or "giving birth"). When you run a command, a new process is created which takes all of its information from the parent. Essentially, it's a copy of the parent - it's a new bash shell, which then sets ...


3

There is a built-in procedure for that. set serveroutput on declare feature_boolean number; aux_count number; feature_info clob; begin dbms_feature_data_guard(feature_boolean, aux_count, feature_info); dbms_output.put_line(feature_boolean); dbms_output.put_line(feature_info); end; / Sample output when Data Guard is not used: 0 Data Guard ...


2

Some notes first: Considering that Accounts has a unique constraint on (account_type, account_store), a Payment seem to be associated with only one Account. That suggests that the FK from Payments should reference Accounts (and not Stores). This change will also solve issue #2. Adding account_type to Payments (and modifying accordingly the foreign key to ...


2

The method you describe is ok. This method was the backup method used before Oracle introduced RMAN and is still valid. It is still used by tools that do snapshot backups (like Netapp's backup tool for Oracle) and I often use this in similar situations. You also should make a controlfile backup if all the controlfiles are on these disks.


2

While copying a tablespace, it automatically includes data files and indexes associated with it. You need to make sure that tablespace is self contained. Confirm that tablespace is self contained execute DBMS_TTS.TRANSPORT_SET_CHECK('<TABLESPACENAME>', true); Use the TRANSPORT_SET_VIOLATIONS view to check if any violations condition exists select * ...


1

No. The rman command 'BACKUP FULL ...' makes a backup of the datafiles but does not backup any archivelogs. If you want to backup archivlogs you have to make an archivlog backup too. This can be done by adding the 'PLUS ARCHIVLOG' clause to the 'BACKUP FULL' command or by issuing a 'BACKUP ARCHIVELOG' command after the 'BACKUP FULL' command. Online ...


1

From the Oracle 11g Documentation: A datafile can be associated with only one tablespace and only one database. So you don't have to worry about losing data from another tablespace.


1

Based on Paul White's answer here is my solution. It skips only weekends and groups rows without comment. WITH GroupStart AS ( -- Identify the start of each new group SELECT td.id, td.holidaydate, td.holidaycomment, CASE --New group, if more then two days between two dates (more than a weekend) WHEN ...


1

If you can create a snapshot of everything at the same time, you do not even need backup mode. Backup mode (User Managed Backup) is not deprecated, but RMAN is the preferred tool for making backups.


1

I would do a shutdown of the database to be sure that really nothing is written on the filesystem of the SAN. Do you have your archivelogs on the same filesystem? Restart it after you have made the snapshot. The alter database begin backup; is in the 11g documentation so it must be still valid (have not checked it for 12c). Do you make full backups with ...


1

Try the following: SELECT ART.NEWS_ARTCL_ID, ART.NEWS_ARTCL_TTL_DES, ART.NEWS_ARTCL_CNTNT_T, ART.NEWS_ARTCL_PUB_DT, ART.NEWS_ARTCL_AUTH_NM, ART.NEWS_ARTCL_URL, ART.MEDIA_URL, ART.ARTCL_SRC_ID, SRC.ARTCL_SRC_NM, MED.MEDIA_TYPE_DESCRIP, LIK.TOTAL FROM RSKLMOBILEB2E.NEWS_ARTICLE ART, RSKLMOBILEB2E.MEDIA_TYPE ...


1

You won't need downtime just to add additional redo logs to your redo groups. Take a look at this: Oracle Configuration Best Practices And then look at this: Creating Redo Log Groups and Members You will need downtime to add additional control files: Creating Additional Copies, Renaming, and Relocating Control Files


1

First, it is important to understand the purpose of SYSAUX tablespace. As the name implies, it is intended to support system tablespace, by holding metadata about database components and other frequent changing data, such as reports. Docs: "If the SYSAUX tablespace becomes unavailable, core database functionality will remain operational. The database ...


1

The note you provided is regarding issues with shutdown: Bug 8299200 - Shutdown immediate hangs (Doc ID 8299200.8). Is it the correct doc you wanted to refer? Have you recently upgraded to 11.2.0.3? If so, there's this MOSC note that might be helpful, referring to a bug that causes Clusterware Synchronization Services operations to be very slow, leading to ...



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