New answers tagged

0

You don't need a return statement, because it is using OPEN and FOR... It is the same like RETURN... The error is in the name of the table, you put it in "" double quotes. Remove that, use simply the name of the table, and use the type SYS_REFCURSOR like this: CREATE OR REPLACE PROCEDURE ProcSelectEveryThing(cursor_ OUT SYS_REFCURSOR) AS BEGIN OPEN ...


0

The storage interaction on Exadata is done via ASM on the database servers, that talks to the cell storage servers using an interface layer called libcell rather than the usual disk IO layer. The InfiniBand network is used for all storage interactions. Apart from the initial setup (which is done as part of the Exadata deployement), the databases are handled ...


0

I do not know what you mean by the "Microsoft" way, but Exadata uses ASM. Administering Oracle ASM Disk Groups on Oracle Exadata Storage Servers http://www.oracle.com/technetwork/database/availability/maa-exadata-upgrade-asm-2339100.pdf ASM is not specific to Exadata or any hardware, you can use it on any supported platform, even on Windows, so you handle ...


0

Your question is too broad for any answer here to fully address, so I'll just address one point. For the major query type of "Give me the latest data generated by a device", you could create a new column in the table that gets the same data as the "data generation time" column and then have a periodic procedure that nulls older values in that column for ...


0

You cannot put the datafiles in Offline when your DB is in No Archive Log mode. So below are the steps to recover the database considering current situation : Shutdown immediate; startup nomount; Recreate the control file using backup trace. : alter database backup controlfile to trace as '$ORACLE_HOME/dbs/control_new.sql'; Now make changes in the ...


2

Archiving the Database Audit Trail Scheduling an Automatic Purge Job for the Audit Trail Manually Purging the Audit Trail Basically you copy the audit trail to another table, e.g: INSERT INTO table SELECT ... FROM SYS.AUD$ ...; INSERT INTO table SELECT ... FROM SYS.FGA_LOG$ ...; You can just export and drop these tables, then import them when you need ...


1

That's exactly the kind of thing that oracle AUDIT is created for. The basic view is DBA_AUDIT_TRAIL, though there are several others. By defalt, Oracle has some auditing already enabled, but you may want to review and modify. Also you want to use the dbms_audit_mgmt package to move the audit tables out of the SYSTEM tablespace into their own dedicated ...


2

Can nologging in certain tables boost the performance? Not for a normal transactional load. nologging only affects some very specific cases of DML (essentially direct-path inserts) and some DDL (see logging_clause). So essentially only for bulk data-loading scenarios. If that's not what your database is doing, it won't help at all. If it is what your ...


2

The installation of a PSU is not complete without the execution of the postinstall script. Opatch works at file level, it replaces/relinks files in the Oracle home. Changes inside the database are performed by running the postinstall script. Sometimes I see DBAs forget this step. The postinstall script maintains the SYS.REGISTRY$ table (on which the ...


0

@Balazs Papp's answer is of course correct. Oracle has not implemented CREATE ASSERTION and no other major DBMS has. The specific assertion though can be as easily implemented with a simple UNIQUE constraint: ALTER TABLE collaboration ADD CONSTRAINT ir_collaboration UNIQUE (ngo, id_employee) ; No two rows with same ngo and same id_employee will be ...


1

Database SQL Language Reference There is no CREATE ASSERTION in Oracle. RDBMS products do not necessarily implement all features in the SQL standards. And to add to the above: Check Constraints Restrictions on Check Constraints The condition of a check constraint can refer to any column in the table, but it cannot refer to columns of other ...


1

The initialization parameters are not supposed to change while bouncing the database except in one case, that is if the modification was only for currently running instance(SCOPE=MEMORY). The following are the steps to modify initialization parameters using Enterprise Manager. To modify initialization parameters for the currently running instance, and ...


1

I am using these two functions in my application: CREATE OR REPLACE FUNCTION Ip2Decimal(IP IN VARCHAR2) RETURN INTEGER DETERMINISTIC IS DecimalIp INTEGER; BEGIN SELECT SUM(REGEXP_SUBSTR(IP, '\d+', 1, LEVEL) * POWER(256, 4-LEVEL)) INTO DecimalIp FROM dual CONNECT BY LEVEL <= 4; RETURN DecimalIp; END Ip2Decimal; and CREATE OR ...


-1

I think you have to include the column bus in the group by


0

I have not found any Oracle database build-in function to convert Decimal number to IP Address. You can create one function on your own to do the job. SQL> CREATE TABLE test_ip(ip_address number); Table created. SQL> INSERT INTO test_ip VALUES(173015430); 1 row created. SQL> INSERT INTO test_ip VALUES(173015318); 1 row created. SQL> ...



Top 50 recent answers are included