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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jayjaybigs

  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

    DATABASE LINKS ACCROSS SEVERAL SERVERS

    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

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

    Need to drop a tablespace EXAMPLE

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

    Need to drop a tablespace EXAMPLE

    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...
  6. 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 =...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. jayjaybigs

    Copy database.

    Thanks Mufasa for this effort.
  15. jayjaybigs

    Copy database.

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

Part and Inventory Search

Back
Top