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!

  • Congratulations Mike Lewis 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. Georgdba

    Klone of SQLServerdatabase

    i took a SQLserver-Backup (without any error) and tried to restore this fine backup of another machine with similar configuration. But it doesn't work. For Backup SQLServer did ask for the databasename and got it in long form, i.e. test-data. Next more SQLServer did ask for the Logfile-name...
  2. Georgdba

    view Oracle dbms packages

    hi - try this sql - command : select distinct object_type,status from all_objects where upper(OBJECT_TYPE) like 'PACKAG%' ; greetings george
  3. Georgdba

    multiple oracle home best practice

    Hi - i had a lot of trouble to install to diffrent ora-version in the same Oraclehome. It caused the general great messages : end of communication channel !! At this moment there is NOGO. executables in $ORACLE_HOME are overwritten, badlinked and so on. No other way than install the version...
  4. Georgdba

    How do I import a .dmp file?

    Hi - An .dmp-file cna be a diffrent thing. For an import of full database ( or a user-schema ) you has to setup the right 'enviroment'. More than this -owner of schema with right privs/tablespaces/space- the oracle version shut be convenient( i.e. is it the same version ???) If there is an...
  5. Georgdba

    Hi all, One of our table reached m

    One way more is to modify the storage parameter of that Tables/idxes which will grow extraordinary (because migration and defragmentation). Georgdba
  6. Georgdba

    System tablespace

    Hi - this failure is very common but help is near - please give a little more details about OS-system and Oracle Server version. Best way should be recreate the DB-Objects in the right Tablespace by the SchemaOwner (not by DBA). Helpful would be the total size of tables, indexes .. greetings...
  7. Georgdba

    firewall in oracle 8.1.7 on sco unixware7

    Hi to implement a firewall IN your Oracle Server is not a good idea. A usefull firewall should be placed before access to the database is posible. Note: it wount be supported by ORACLE greetings Georgdba
  8. Georgdba

    how to firewall in oracle 8.1.7

    Hi - I think it's not a good idea to implement a firewall within your Oracle Server. To use it on a seperate Server should be the best way- spec. for security reason. greetings Georgdba
  9. Georgdba

    New Sun server

    why not - all the doing on SUN-Server is sunny. greetings George
  10. Georgdba

    Upgrading from 8.0.6 to 8.1.7.2.0 ?

    Hi - the best way to solve your question depends on the mass of data. I had this requierement solved with the EXPORT -Tool (across platforms from HPUX -> AIX) EXPORT tablespaces transfer via local Net (or Tape) an Import with appr. User. In case of ts >2GB use the filesize clause in...
  11. Georgdba

    Help on user Privileges

    Hi - shure you have granted dba to user1 or the user has privileg on that object greetings Georg

Part and Inventory Search

Back
Top