How can we set the profile option from a PL/SQL proced开发者_运维百科ure? Check here for Oracle documentation on PL/SQL Hierarchical Profiler.
I have installed Oracle 10g in one of my office\'s computer. I want to keep this as database server. I am developing a .net project which will communicate with the database server from client machine
I have an existing database with tables which each have 4 partitions (there are tables using both RANGE and HASH partitioning).
I\'m trying to update an oracle database so that it\'s schema matches a second database exactly.In doing so I\'ve hosed something. I can\'t create or drop any object.
The sum of sm$ts_free.bytes and sm$ts_used.bytes is not equal to sm$ts_alloc.byte开发者_JAVA技巧s.
I want to run 200+ select queries and append the results to a file. All queries are the same the only difference in the date-time variable. I don\'t have privileges to create a routine that\'s why I h
I\'ve got a load of materialized views, some of them take just a few seconds to create and refresh, whereas others can take me up to 40 minutes to compile, if SQLDeveloper doesn\'t crash before that.
I have Oracle (10g Express Edition) installed on one pc. Visual Studio 2008 SP1 is installed on another pc.
I am having table with clob column & trying to insert SIGNED character data which contains =176048 characters, it throws error 开发者_如何学Gohas Insert exception data transaction java.sql.SQLExce
Is there an开发者_运维问答y data type greater than CLOB in oracleNo, there is no bigger datatype for storage in the database.In Oracle 11G the limit has increased from 4GB to \"(4 GB - 1) * DB_BLOCK_S
加载中,请稍侯......