Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JJSmith

    OWB Mapping - package becomes invalid

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

    Oracle Warehouse Builder - Unable to deploy mapping

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

    insert sys date-time

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

    Please Help - Control File Errors

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

    simple question, please help...

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

    Large Roll Back Segment

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

    Please Help - Control File Errors

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

    Packaged procedures

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

    URGENT - CONNECTIVITY PROBLEM

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

    equivalent of JOIN in Oracle

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

    Oracle Error ORA-01652

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

Part and Inventory Search

Back
Top