Search results for query: *

Try Oracle MetaLink on that site Oracle provide an uninstall document to walk though the uninstalling of various version on the Window platform

DataGuard is good option. The OS does not have to the same only the version of the database. After the database is replicate all have to do is just switch the user point at that instance and still have fail backup any thing go wrong.

#!/bin/ksh FTPresult=X ###User=xxxx #Host=xxx.xxx.xxx.xx #File=test.pag #Password=xxxxxx #export FTPresult User Password File Host #FTPresult=`ftp -n 2>$1 << eof FTPresult=`ftp -ni << eof open ${HOST_MACHINE} user ${USER} ${PASSWORD} cd \directory put ${PAGER_FILE} #file to send to destination...

I trying to write to a text file via the xp_cmdshell command store procdure. But I am unable to create multiples lines within the file. I would like some suggest if possible. Or source code would be better writtten using T-Sql.

If you just want to move the database to another server depending on the OS. If you are using NT you can just copies all of the file to the destnation directories and create a service for the instance then re-create the control by using a copy of the control from the previous server that you are...

Try turning on Oracle Audit the will capture all events

There is some other thing you might check 1. The Listener.ora should have the new database add to it. 2. Did you create a services for the new database that will start on reboot. Locate in Control Panel|Services 3.You can connect via the GUI by also entering the connect string that was add to...

The answer you question can you have two instance of Oracle on the same machine is YES. Now the first thing that you mention was that you installed a later version of the database 8.1.x this is all good because hopefully they are in different Oracle Home directory. The answer about have the...

This conversation sound like you are try use SQL server theory on and Oracle database. One thing you should consider while you attempting to strip your tablespace for performance. Is to ask your self if your are use RAID and if so it dose matter how you display your table because they will still...

There several ways to move data from one tablespace to another. 1. You can create the new tablespace and rebuild the table to go into that particular tablespace. With the rebuild rebuild table storage(initial next pctincrease maxextents) tablespace 2. Then after rebuilding the table you can...

This is a window api call The GetFileSize function retrieves the size, in bytes, of the specified file. DWORD GetFileSize( HANDLE hFile, // handle of file to get size of LPDWORD lpFileSizeHigh // address of high-order word for file size ); Parameters hFile Specifies an open...

Try using the API call GetCurrentDirectoryA(max_path,CurDir);

IF you are using DHCP for all of your client machine the IP will change periodically. I agree that machine name will stay consistant. But if you must have the IP address try using windows API calls.