SET SERVEROUTPUT ON SIZE 1000000
BEGIN
FOR cur_rec IN (SELECT object_name, object_type
FROM user_objects
WHERE object_type IN ('TABLE', 'VIEW', 'PACKAGE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')) LOOP
BEGIN
IF cur_rec.object_type = 'TABLE' THEN
EXECUTE IMMEDIATE 'DROP ' || cur_rec.object_type || ' "' || cur_rec.object_name || '" CASCADE CONSTRAINTS';
ELSE
EXECUTE IMMEDIATE 'DROP ' || cur_rec.object_type || ' "' || cur_rec.object_name || '"';
END IF;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.put_line('FAILED: DROP ' || cur_rec.object_type || ' "' || cur_rec.object_name || '"');
END;
END LOOP;
END;
/
This Blog is dedicated to administration of Oracle database, Oracle E-Business Suite, Linux, Windows, Weblogic and other miscellaneous Oracle and non-oracle products...
Ознаке
- Administration (6)
- Alias (1)
- Apex (2)
- Apps Tables (1)
- Archiving (1)
- Clean (2)
- Concurrent Managers (3)
- Configuration (1)
- DB_Link (1)
- DataDictionary (2)
- EM (3)
- Files (7)
- Filesystem (1)
- Forms (2)
- Fra (1)
- FreeSpace (2)
- Hardware (1)
- Index (1)
- Install (1)
- Invalids (3)
- Keypar (1)
- Lock (2)
- Log (4)
- Mail (1)
- Memory (2)
- Mount (4)
- Network (6)
- OUI (1)
- Parameters (3)
- Patching (6)
- Performance (2)
- Port (1)
- Process (1)
- RMAN (3)
- Runlevels (1)
- Samba (1)
- Script (2)
- Selinux (1)
- Session (5)
- Tablespace (2)
- Tablespaces (3)
- Tar (3)
- Users (4)
- Version (3)
- Vnc (2)
- Workflow (1)
- Xen (3)
- Zip/Unzip (2)
четвртак, 28. новембар 2013.
Delete all user objects script
Пријавите се на:
Постови (Atom)