Search results for query: *

dps - I can tell you that you need to use the tool called "Design Editor" to create the table definitions that you want. When you have them you can generate the DDL with that tool as well.

dps - After I played around with the designer for a while I was able to figure out what I needed to know. I never actually used the tutorial. Maybe someone else in the forum can answer the question for you. Sorry, I couldn't be of more help. Good luck. -BH

Some important information that I forgot to include. We are using Oracle 8i on Windows NT. We are using EJBs with and application server and connection pooling. The problem may have something to do with using the result set in this environment. I don't remember the exact error message when I...

Hopefully this is a simple question... Is it possible to use a scrollable result set with the Oracle JDBC driver and move backwards as well as forward. I have been able to use it to move forward using next(), but I can't perform any other operations with it. Does the driver support it? Does...

That may be the problem, but I'm not worried about the tutorial anymore since I figured out how to do what I needed to do. At any rate, thanks for the response.

Thanks for the response. Let me explain a little bit more about what I want to do. I have been assigned to create an install program that loads device drivers and registers them for a piece of hardware. I have been using InstallShield to create the install. All that the install does is copy...

I was wondering if there is a tool available that will help create .inf files for Windows 2000. If not, where is the best place to look for documentation on how to write an .inf file? Thanks, Bennett

I am trying to perform a silent install for Oracle8i on Windows NT. I took the svrminimal.rsp file and modified it to fit my needs. However, when I try to run the setup.exe with a response file specified the response file is not found. I even tried putting the response file in the same...

I am developing an application that connects to an Oracle 8i database on Windows NT or 2000. The application is written in Java, and I am using JDBC to access the database. I would like to have an option in the client application to start a database backup. This would be a hot backup, and the...

I am working on an application in Java, and I have written some code using a JDBC connection and prepared statements to send SQL commands. I can put a tablespace into the begin backup mode with "ALTER TABLESPACE SYSTEM BEGIN BACKUP" inside of the prepared statement in Java. However...

Sorry that I have to ask this dumb question, but I figure that somebody else could help me before I waste too much time. I am trying to start the designer tutorial. In the online manual it says to start a program called "Oracle Designer for Tutorial User". It is supposed to be in...

Hi, I'm still learning quite a bit about Oracle, but I think I know what you need to do. Did you create a repository for the Oracle Management Server? If you haven't done this then the service won't be able to start. Start up the "Configuration Assistant" and create a new...

I am trying to use the "startup" command without any parameters in SQLPlus. When I issue the command I get the following message because the file that it is looking for no longer exists: LRM-00109: could not open parameter file 'E:\Oracle\Ora81\DATABASE\INITauc3.ORA' ORA-01078...

Thanks! I was able to make the command work using the path to the init.ora.

Thanks for the response. I can start the database with DBA Studio, I used the only init.ora file that I have. I really need to figure out how to mount the database with RMAN so that I can perform a backup. I am open to any other methods of doing a "cold" backup. If you have any...

Here is part of the listener.log file (maybe it will help)... 03-APR-2001 12:11:43 * (CONNECT_DATA=(SERVICE_NAME=auc.geg.mot.com)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.7\bin\jre.exe)(HOST=AZSC5028)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=137.162.75.74)(PORT=1221)) * establish *...

I am trying to perform a backup using the RMAN utility. I am doing a "cold" backup so I shutdown the database and then went into RMAN (connecting to the target with the nocatalog option). When I try to mount the database, I get the following error message: RMAN-04014: startup...

Thanks for the response. I read the thread that you included in the response, and it prompted me to change some things in the init.ora file. I made the necessary changes, but I can't verify the archive log status. When I try to use "svrmgrl" I get the dreaded "ORA-12560...

I am using Oracle 8i Personal Edition, and I want to switch from NOARCHIVELOG mode to ARCHIVELOG mode. After checking the box for ARCHIVELOG mode in the DBA studio GUI, I get the following error when the database tries to restart: "The exception (org.omg.CORBA.BAD_PARAM) occured.&quot...

I just installed Oracle 8i Enterprise Edition, and I am having some trouble getting one of the services to start. As a result, I am not able to login to the the console because the management server is not running. I am running Oracle on a Windows NT machine, and the event viewer reports the...