Skip to content

Monthly Archives: May 2007

Showing special characters in filename

Thursday, May 3, 2007

Sometimes, especially if your terminal is not set correctly, you accidentally create files that have backspace in their name. To see the full name, you can use the -b option to ls : > ls -b gjdhjd\177\177.txt This file has 2 backspace characters in the name, they are shown as \177. That will give you [...]

Filed in Linux/Unix | | Comments (0)

Removing all objects for a user

Thursday, May 3, 2007

From this post, here’s a way to purge all the objects for a user. You can use this if you don’t have SYS access. SELECT ‘drop ‘||object_type||’ ‘|| object_name|| DECODE(OBJECT_TYPE,’TABLE’,’ CASCADE CONSTRAINTS;’,';’) FROM user_objects You should spool this to a file and then run that file. Then to really remove them, use : purge recyclebin; [...]

Filed in Oracle | | Comments (0)