Search results for query: *

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

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

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

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.

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

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.

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

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

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

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

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

and rownum=1

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.

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

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

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

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

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.

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

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