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

    analyze table after insert a large number of records?

    The Oracle PL/SQL Packages and Types Reference book has all the details and syntax.
  2. evatype2

    Oracle Instance Hassles

    I've gotten this message before. For me, it never had anything to do with SQL Net or the listener (other than the instance couldn't connect because it wasn't coming up correctly). Every time I got this message I was short of memory or semaphores. Once I had to connect as SYSDBA (for some...
  3. evatype2

    Drop Table Generates TLog???

    Never used to. Databases really make a distinction between transactions and DML. A transaction has a begin (and hopefully, if coded correctly) an end. A transaction does work on the DATA in the database. So, the transaction log keeps track of these changes so you can recover all the work...
  4. evatype2

    How to add user library to rtsora on AIX

    Sorry I have not done this, but logically you have a problem. What about calling a stored procedure that uses MQSeries and not try to link MQSeries directly into the COBOL program. Also, doesn't Oracle sell a gateway for this product.
  5. evatype2

    import time consuming

    Are you looking at the import as a method of recovery or to refresh a development environment? If your db takes 4/5 hours to export, it is a medium large database. It may be time to look at other methods of refresh/recovery. I'd take a look at RMAN. It can be used to restore a database in its...
  6. evatype2

    Oracle 8.1.7.3 on W2K and MTS

    Did you ever consider going to a real operating system like UNIX? Sun, HP, and IBM all have some very nice, scalable, 64-bit machines that are known, proven entities.
  7. evatype2

    dbstart not working

    This is a documented bug. You need to copy dbstart to dbstart0 and then edit the code that looks like this: if test -f $ORACLE_HOME/bin/svrmgrl; then VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk ' /PL\/SQL (Release|Version)/ {substr($3,1,3) ...
  8. evatype2

    OMS (Oracle Management Server)

    OMS (Oracle Management Server) is a task/process that needs a repository (set of database objects) in an Oracle instance. I run my OMS on a Sun Solaris. You can also run it under MS Windows/NT/etc. To quote the HELP in DBA Studio: Before you start the Oracle Enterprise Manager Console, you...
  9. evatype2

    What is a datapump?

    Do you have PowerBuilder in your shop? It actually had a DTS called data pump.
  10. evatype2

    SQL 6.5 Logsegment full, but it isn't

    You need to have the databases mapped across your devices exactly the same if you want to restore off a dump. Dumps are not data exports, they map to the physical device layout. Haven't worked with the product for a while, but you are getting error messages that go back to 3.x and 4.x. Look at...
  11. evatype2

    SQL*Loader question.

    Yuck. Create an intake table in Oracle and then use SQL to spread the data to its proper place.
  12. evatype2

    optional parameters in procedure

    and rownum=1
  13. evatype2

    Accessing LDAP via Oracle 8i

    Oracle 8i actuall provides an OID (Oracle Internet Directory) feature that is supposed to interface with LDAP (NDS included if you are a Novell shop). http://www.oracle.com/oramag/oracle/01-jan/index.html?o11o8i.html contains an introductory article.
  14. evatype2

    Lsnrtcl

    Assumption: YOU ARE IN A UNIX ENVIRONMENT Contrary to the information on when you start and stop the listener based on what version of Oracle 8i you are running, you should understand that the listener is a separate process from the database instance. It exists to communicate between the client...
  15. evatype2

    How do I change the Server Collate thing?

    Well if Microsoft hasn't completely trashed the original Sybase core the command would be: ALTER DATABASE dbname COLLATE collatename Don't remember if you need to reboot, it has been years. You can also set COLLATE at different levels, but I think this is a needless pain. I prefer, when...
  16. evatype2

    oracle startup after shutdown

    No, it won't do anything to the other instance. The ORACLE_SID is an "environment" variable. It points you to the instance you want to use (sqlplus, srvmgrl, etc.). Switch between them as needed (see $ORACLE_HOME/bin/oraenv script that comes with UNIX based servers). Also, make sure...
  17. evatype2

    oracle startup after shutdown

    Exit the server manager and set your ORACLE_SID=myotherdb, then try it again.
  18. evatype2

    exports clear of integrity issue

    Include the export parm CONSISTENT=Y. The default is N, so you need to include this parm if you are concerned about updates occurring during your export.
  19. evatype2

    how can I insert unix-data into an sql script?

    I use a simple, but reliable method to do this sort of thing. In your script, do what you need to format the df output ("cut" fields, etc) into a file. I then call sqlldr (sql loader doc. is in utility manual with import/export) to load the formatted file. You will need a .ctl file...
  20. evatype2

    Database migration

    You really should have a DBA do this, especially if you are migrating production databases. The conversion scripts are part of the 8.x install CD. Make sure you have a base install for the version, e.g. 8.1.6.0.0. Back-ups are a good thing. You need to read the associated migration manuals...

Part and Inventory Search

Back
Top