Recent content by Striker99

All, I have the following direcotry under /data with full access. drwxrwxrwx 4 user3 user3 96 Jul 18 08:39 scripts I have created a symbolic link to this direcotry from / with the following rights/users lrwxr-xr-x 1 root sys 12 Jul 16 12:09 scrpts - data/scripts My problem is the i...

All, I have Oracle 8.0.6 database running and have some important data. I have to migrate to version 8.1.7.2.0 and preserve the data. The 8.0.6 is on HP UX 10.2 and 8.1.7.2 is on HP UX 11.0. Any suggessions on what's the best way to do this. Thanks in advance, striker99

All, I have Oracle 8.0.6 database running and have some important data. I have to migrate to version 8.1.7.2.0 and preserve the data. The 8.0.6 is on HP UX 10.2 and 8.1.7.2 is on HP UX 11.0. Any suggessions on what's the best way to do this. Thanks in advance, striker99

All, Could you please advice me the version of Oracle Report availabe on HP UX 10.2. I am using Oracle 8.0.6.0.0 Thanks a million, striker

All, I am relatively new to comm's and need all the help i can get to solve my problem. My question is, how do i calculate the bandwitdh for my application. My client application is connecting to Server thro a remote access. I understand that this depends on the size of the message transfered...

All, I have to change certain storage parameters of the tables & indexes. Changing for tables and explicit indexes was not a problem, since i could import the dump file into a text file and then edit that file. But for the implicit indexes ( PRIMARY and UNIQUE KEY CONSTRAINTS) its causing some...

All, I got this script off the net and trying to make it work, without much luck. I am not getting any error message, but its not writing anything to the spool file ? any idea why ? cheers, striker99 -------------------------- set verify off; set termout off; set feedback off; set...

All, I am using Oracle7.3.4. When i connect sqlplus as system/manager and list all the application related indexes from dba_indexes it shows about 700 indexes on the database. But when i export the database and then import using INDEXFILE=filename.txt, it shows only about half of the indexes...

Thanks guys, Could you tell me how do i make decision on what should be by initial/next parameters. Say if my file size is 2G's ? Thanks in advance, striker99

All, Could anyone please tell me what is the relations between a extent and a datafile ? What are the implications of extent size on datafile ? Thanks, striker99

All, Can i import the dump file into a text file ? If so, could you please let me know how ? Rgds, striker99

All, Could you please explain to me what this SQL statment does, sqlplus -s system/manager >/dev/null <set echo on thanks, striker99

All, Could any explain to me what this sql statemene does please. sqlplus -s system/manager >/dev/null <set echo on Thanks, striker99

All, I am using Oracle7.3.4 and it is running on a production system. I have to migrate this to a new hardware environment along with some database structure changes. How do i accomplish this task ? 1) Create the database from scratch ( from the initial scripts ) and apply any changes made...

Thanks of your reply. I do not want to restore from the back up tape. The idea is to create the database similar to the existing one and then change the parameters to reflect the changes done in the benchmark( performance test) and then load the data at the later stage. thanks, striker99