Search results for query: *

The basic problem here is that your package has a dependency on the sequence. When you drop an object Oracle will check if anything has a dependency on it and if so mark it as invalid. This shouldn't be a problem normally as oracle will re-compile the package at run time. It can be a problem...

The use of database links when working with mapping it to allow you to import the meta-data/description of the object without having to manually enter the details. When generating mapping for deployement you must remove these links prior to generating as the run time mapping/pls uses rowids...

create table time_exp ( date_time date ); insert into time_exp ( date_time ) values ( sysdate ); select to_char(date_time,'DD-MM-YYYY, HH24:MI:SS') from time_exp; Dates are always stored with a time element but just selecting the date will only display the date, if you want the time then you...

There should be no need to re-install the software. It is re-creating the database that is necessary. Are you creating a default database when installing the software. If you are then the database is not created - it is copied from the installation media. Can you get the database actually...

Editors need to be configured and may not always be available. l = list current statement ( as a numbered list ) <num> = put line <num> in context ( when listing line has an * ) c/old/new/ = change old string to new string on line in context. a str = append str on the end of line in context...

alter rollback segment VLRB1 online; run script ..... alter rollback segment VLRB1 offline;

There are 2 possible reasons here: 1. You tried to resize a datafile. 2. The datafile has autoextend on - in which case the system re-sized. Normally it would be a case of backup, dropping the tablespace and recreating, then restore data - how ever in your case it is the system tablespace that...

One of the performance gains is to do with parsing. When you store a package/procedure the source is parsed and checks carried out for syntax, precence of refrenced objects - tables, views other package/procedures etc. On completion a valid 'parsed' version of the package/procedure is stored...

If you are going through a Firewall, and your server platforms are NT, then you must ensure that you set up a SQL*Net/Net8 Proxy, such as Net8 Connection Manager, if none is provided by the Firewall vendor. The reason is that, even though the port is open, the TCP layer will REDIRECT the port to...

Assuming you want a products ProductID, Name and Description from the product table along with the equipmentID and Equipments from the Equipment table when there is a row in both tables matching on equipmentID then: SELECT Product.ProductID, Product.Name, Product.Description...

Your problem would require you to supply much more detail for someone else to resolve it - however in answer to your question of monitoring the growth of temporary segments then: As a user with access to DBA views, use the query; SELECT segment_name,extents,bytes FROM dba_segments WHERE...