Tag Info

New answers tagged

0

connect to the database machine and check if the firewall is disabled,if not diasble the firewall using the below command as root user service iptables status(used to check the firewall status) service iptables stop(used to disable the firewall)


1

I can't personally think of anything better for on-the-fly resource throttling based on to-the-second stats than Resource Manager. It can be a bit of a hassle to set up, but I don't imagine how writing custom code wouldn't just be reinventing the wheel that is Resource Manager. I'm not aware of any reliable 3rd party vendors at this time. I do know that ...


1

It looks to me like the string you're passing in is too long for the UTL_RAW procedure you're trying to call. From the Oracle documentation: There is an error if the sum of the lengths of the inputs exceeds the maximum allowable length for a RAW, which is 32767 bytes. found here: http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/u_raw.htm#ARPLS072 ...


0

Below SQL will work. Insert into My_Table (FILE_NAME, FILE_DATA) Values ('REGISTER.XML', ''||CHR(10)|| ''||CHR(10)|| ' Publisher_1'||CHR(10)|| ''); Here FILE_DATA is a CLOB column which contains XML content. Thanks, Kalyan


0

An alternative for saving an XML Schema in a location were you are able to control it is the XDB Repository: http://docs.oracle.com/cd/B28359_01/appdev.111/b28369/xdb16fol.htm#i1042688 You can create files or select their content via XDB functionality that supports FTP/WebDAV or HTTP...


1

Wouter got, hopefully, useful answers here: https://community.oracle.com/message/12608939 That said, being the Oracle ACE Director for this technology. Oracle XMLDB functionality is nowadays so interwoven with the Oracle database that this is an MANDATORY (install) functionality for Oracle 12c and onwards. It is the basis for much in the database like ACL ...


0

...but then again... XML has nothing to do with SQL, so some normal reasoning might not apply...(regarding object types for example). The first example is an XMLType and depending on your database version the underlying store definition might be Securefile CLOB or Securefile Binary XML. The first one is deprecated from Oracle 12c and onwards due to ...


0

select LAST_LOAD_TIME, LAST_ACTIVE_TIME from v$sql where sql_id = Your SQL ID Hope this will give you the expected result


0

We ended up using an export from the next day and doing a table-level import. The table was created and all rows were imported. It is concerning to us that this workaround succeeded. There were no indication in the export log of the problem export that there were any issues with the export. We did not try the suggestion to use a different user id than ...


0

I suspect this may have something to do with you starting impdp as sysdba. Please see the note in http://docs.oracle.com/database/121/SUTIL/dp_export.htm#SUTIL824: "Do not start Export as SYSDBA, except at the request of Oracle technical support. SYSDBA is used internally and has specialized functions; its behavior is not the same as for general users." ...


0

Try something like: SELECT * from ( SELECT sql_id, operations, options AS options_a, STR(null) as options_b from table_a UNION SELECT sql_id, operations, NULL AS options_b, options as options_b from table_b ) tmp GROUP BY sql_id, operations HAVING( options_a != options_b OR options_a IS NULL OR options_b is NULL ) This ...


1

Assuming that sql_id has a unique or primary key constraint, you can do this with FULL JOIN (or LEFT JOIN if there are no new "inserts" in table B, or just JOIN if there are no inserts and no deletions): SELECT COALESCE(a.sql_id,b.sql_id) AS sql_id, CASE WHEN a.operation = b.operation THEN 'matched' WHEN a.operation <> b.operation ...


1

To view the differences, use the EXCEPT operator (SQL Server): SELECT sql_id, OPERATION, OPTIONS FROM TableA EXCEPT SELECT sql_id, OPERATION, OPTIONS FROM TableB ORDER BY sql_id When you suspect data was deleted from TableA, you also need to reverse the tables: SELECT sql_id, OPERATION, OPTIONS FROM TableA EXCEPT SELECT sql_id, OPERATION, OPTIONS FROM ...


3

The documentation clearly describes the precedence for NLS settings: http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch3globenv.htm#NLSPG188 1 (highest) Explicitly set in SQL functions 2 Set by an ALTER SESSION statement 3 Set as an environment variable 4 Specified in the initialization parameter file 5 Default ...


1

On Win7 you also must be running this as admin, or it will fail to be able to read the path variable, and install halts.



Top 50 recent answers are included