Recent content by jayjaybigs

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

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

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

I hoping to drop the objects withing the tablespace first. However when I go to drop the user with cascade option to drop the objects as well, I ws getting the following errors. ORA-03113: end-of-file on communication channel DROP USER "QS" CASCADE ORA-01001: invalid cursor ORA-00600...

I wanted to drop EXMAPLE tablespace because it only holds example datafiles which we don't need. This EXAMPLE was created by the Oracle database configuration Assistance. I have used the DROP TABLESPACE EXAMPLE INCLUDING CONTENTS AND DATAFILES. I got the 'ORA-23515: materialized views and/or...

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 =...

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

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

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

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

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

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

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

Thanks Mufasa for this effort.

Also, I am only interested in copying the schemas not whole database.