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 Rhinorhino 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: *

  • Users: jayjaybigs
  • Content: Threads
  • Order by date
  1. jayjaybigs

    Script to select users in the database.

    Hello All. Does anyone has a script to select users in the database. That is, users with only read access in the database. I am currently using this select null grantee,username granted_role from dba_users But I am not getting the desired result. Thanks
  2. jayjaybigs

    Drop and create links

    Hello, I have several links in a database. My object is to: 1)Output each link. 2)drop the link 3)re-create the link with a new password. Here is my effort: ======================== begin for r in (select owner,db_link,username,host from dba_db_links where owner = 'PUBLIC') loop...
  3. jayjaybigs

    Need to drop a tablespace EXAMPLE

    I wanted to drop the tablespace EXAMPLE and I got this error - ORA-23515: materialized views and/or their indices exist in the tablespace Therefore I used the statement below to find the existing objects in the tablespace; select owner, object_name, from dba_segments where tablespace_name =...
  4. jayjaybigs

    DATABASE LINKS ACCROSS SEVERAL SERVERS

    Hello, I have several databases on different servers that are currently being assessed by several applications via database link. My aim is to rebuild the database link periodically as a temporary security measures. Bearing in mind the different servers, how can I rebuild the database links...
  5. jayjaybigs

    Rename Files in a directory.

    Hi All, I have about a number files in a directory like so: hello.txt hallo.txt hullo.txt hollo.txt Mu aim is rename them as follows: hello1.txt hello2.txt hello3.txt hello4.txt Here is my effort, but I am not getting any love with this script.... #! /bin/bsh $LIST=`ls *.txt` for file in...
  6. jayjaybigs

    Unix Server Security

    Hello All, I am trying to provide security layer on the unix server side. There are two questions I am interested in solving: 1)Would it advisable to periodically change the account of each user on the server. If this can be done by a script, please provide a source. 2)Prompt the application...
  7. jayjaybigs

    Server Security

    Hello All, I am trying to provide security layer on the unix server side. There are two questions I am interested in solving: 1)Would it advisable to periodically change the account of each user on the server. If this can be done by a script, please provide a source. 2)Prompt the application...
  8. jayjaybigs

    Oracle password change.

    Hi All, We are just implementing new applications for our billing group. I have been tasked to come up with a script that will periodically change the password for all the applications connecting to the database. I was wondering if you have any site/scripts that will periodically change the...
  9. jayjaybigs

    Unix level Securtiy - user password change

    Hi All, We are just implementing new applications for our billing group. I have been tasked to come up with a script that will periodically change the password for all the applications connecting to the unix severs. I was wondering if you have any site/scripts that will periodically change the...
  10. jayjaybigs

    Oracle importing failing

    Hello All, I have exported a dump file from 9.2.0.6 version. However, when I tried to import into the another 9.2.0.6 database. I am getting the following errror. IMP-00058: ORACLE error 6550 encountered ORA-06550: line 1, column 33: PLS-00302: component 'SET_NO_OUTLINES' must be declared...
  11. jayjaybigs

    Copy database.

    Hello All, I was givien a list schemas to copy from one database to the other. I intend to use export - import method like the following: exp system@ODSUGPL OWNER=<user> CONSISTENT=Y COMPRESS=Y STATISTICS=NONE FILE=file.dmp LOG=name.log imp system@ODSUGPL FROMUSER=<user> IGNORE=Y...
  12. jayjaybigs

    Sql*Loader Installation

    Hello All, I am trying to install Sql*Loader on existing database using Oracle universal installer. I chose the custom install hoping I can choose Sql*Loader, However, I cannot find Sql*Loader among the listed products. Please help on how I can install Sql*Loader on existing databse server...
  13. jayjaybigs

    Converting from ORACLE RAC to IBM High Availability Cluster Multiproce

    Hello, I was wondering if anyone can provide or point me in the direction where I can get information on How to convert from ORACLE RAC to IBM High Availability Cluster Multiprocessing (HACMP). Regards, JayJay
  14. jayjaybigs

    IBM HACMP Vs. Oracle Real Application Cluster

    Hello, We are contemplating chages in our Oracle Database on AIX. I was wondering if you can point me to a site that will help us to decide which architectiure to go with between IBM HACMP Vs. Oracle Real Aplication Cluster. Any information will be appreciated. Regards, Jay Jay
  15. jayjaybigs

    Change from one instance to another.

    Hello, I have several unix servers which contain several database Instances. I was wondering if there is an easier way to change from one server to the other as suppose to loging out of one instance and loging back in to another on my secure shell(SSH). Thanks
  16. jayjaybigs

    Shell Script that calls a PLS/SQL Proc

    Hello, Does anyone has a shell script that could be excuted from the crontab that calls a PL/sql PROCEDUR from certain directory. The script should take into consideration the following: -- $PROC_NAME is the procedure that needs to be executed -- $ORACLE_HOME is path inwhich oracle is...
  17. jayjaybigs

    Change shell from ksh to bash

    Hello All, I am interested in changing my unix shell parmanently from ksh to bash. Could anyone advise. I am currently doing the change in /etc/passwd file and it is not working. JayJay
  18. jayjaybigs

    disabling all the constraints on a table.

    Hello All, I have several constraints on table. I intend to load big data into the table. However I wanted to disable all the costraints at once like the following: ALTER TABLE STATE DISABLE CONSTRAINT ALL; OR ALTER TABLE STATE ENABLE CONSTRAINT ALL; Could anyone advice if this is feasable.
  19. jayjaybigs

    Application DBA vs. Operational DBA

    I was wondering if anyone has additional input into the above subject. In my view, the differece is as I listed below. Please feel free to add or correct the list with your input. Operational DBA: .convert business units to ERD diagram. .Documentation of data flow withing business units .Data...
  20. jayjaybigs

    Converting database to 10g

    Hello All, I am currently proposing to our organization to convert our database from 9i to 10g. I was wondering if anyone can point me in the direction of any resource (white papers e.t.c.) that will butress my point. Thank you

Part and Inventory Search

Back
Top