Tag Info

Hot answers tagged

3

% is not a valid format specifier for numbers. See the documentation below: Number Format Models


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


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


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

Just start the database normally and run DBMS_DST.UPGRADE_DATABASE Then you must see the messages "An upgrade window has been successfully ended." and "Failures:0" Double check that it succeeded by running: 1: SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME LIKE 'DST_%' ORDER BY ...


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


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

Export the PATH variable. You have missed that. PATH=$ORACLE_HOME/bin:$PATH export PATH


1

It sounds like you just want a CREATE TABLE AS SELECT CREATE TABLE your_new_table_name AS SELECT * FROM your_materialized_view If there are indexes on your materialized view that you want to create on the table, you'd need to create those separately.


1

NOAFFIRM means the redo transport will be acknowledged before writing the received redo to disk (standby redo logs). ASYNC noaffirm means the log transfer method is ARCH right? No, it does not. Without specifying LGWR or ARCH, LGWR is the default. You can check it on the primary database by: select archiver from v$archive_dest where dest_id = 5; ...


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