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 John Tel 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 psyco
-
reduce temp tablespace datafile size
when u do alter users to use the new temp tablespace, you will have to allow for current processes to stop. one of the ways to check which users are using temp tablespce is this script... select b.tablespace ,b.segfile# ,b.segblk# ,round(((b.blocks*p.value)/1024/1024),2) size_mb ,a.sid...- psyco
- Post #5
- Forum: Oracle: All versions
-
DBMS_PACKAGE NOT INSTALLED
have you tried running the script as the user sys ?- psyco
- Post #2
- Forum: Oracle: All versions
