Public snipts » Fotinakis's snipts » oracle

wrap codeloading...

• ∞ Drop all tables and constraints within an Oracle schema

  BEGIN
  FOR c IN (SELECT table_name FROM user_tables) LOOP
  EXECUTE IMMEDIATE ('DROP TABLE ' || c.table_name || ' CASCADE CONSTRAINTS');
  END LOOP;
  END;

  sql

  1

  Drop all tables and constraints within an Oracle schema

  BEGIN
  FOR c IN (SELECT table_name FROM user_tables) LOOP
  EXECUTE IMMEDIATE ('DROP TABLE ' || c.table_name || ' CASCADE CONSTRAINTS');
  END LOOP;
  END;
  

  copy | embed

  0 comments - tagged in 
  • drop, 
  • oracle, 
  • permissions, 
  • sql
  posted by Fotinakis on Jan 29, 2010 at 5:22 p.m. EST

A good read

Fotinakis's tags

• active directory (2)
• admin (3)
• apache (4)
• bash (5)
• bytecode (1)
• c++ (1)
• csv (1)
• db (2)
• debian (2)
• disassembler (1)
• django (5)
• drop (1)
• grant (1)
• history (1)
• hook (1)
• htaccess (1)
• javascript (1)
• jquery (1)
• ldap (2)
• linux (3)
• mac (1)
• macaddr (1)
• modwsgi (3)
• networking (1)
• oob (1)
• oracle (1)
• osx (1)
• oui (1)
• parsing (1)
• password (1)
• passwords (1)
• permissions (2)
• pgdump (1)
• postgresql (4)
• profiling (1)
• psql (2)
• python (4)
• random (1)
• security (2)
• server (1)
• settings (1)
• sql (1)
• ssh (2)
• sshfs (1)
• state (1)
• strings (1)
• template tag (1)
• tokenize (1)
• vmware (1)