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 Chriss Miller 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. matrixcd

    Reinstalltion of Oracle on W2k

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

    Database OS migration

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

    FTP Scripting

    #!/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...
  4. matrixcd

    Create Os file with multiples lines

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

    Moving a database to a new server

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

    Capturing User Name

    Try turning on Oracle Audit the will capture all events
  7. matrixcd

    problem in creating databse

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

    Can Oracle 8.1.6 and Orale 7.3.4 co-exist

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

    Creating Tablespace guidelines please

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

    Tablespaces again please

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

    File size

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

    Current Directory?

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

    Oracle IP Address

    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.

Part and Inventory Search

Back
Top