DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Drop user

  1. 11-03-2005, 02:35 PM #1
    dbasan's Avatar
    dbasan
    dbasan is offline Advisor
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650

    Drop user

    I have a user schema which has to be dropped. The schema has 40000 objects.

    Which is the best possible way to drop them fast?

    Last time when i did for 25000 objects it took 5hrs.
    "What is past is PROLOGUE"
    Reply With Quote Reply With Quote
  2. 11-03-2005, 02:40 PM #2
    KenEwald's Avatar
    KenEwald
    KenEwald is offline Senior Advisor
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Are the objects in their own tablespace?
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need
    Reply With Quote Reply With Quote
  3. 11-03-2005, 03:22 PM #3
    dbasan's Avatar
    dbasan
    dbasan is offline Advisor
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by KenEwald
    Are the objects in their own tablespace?
    no
    "What is past is PROLOGUE"
    Reply With Quote Reply With Quote
  4. 11-03-2005, 03:44 PM #4
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Quote Originally Posted by dbasan
    I have a user schema which has to be dropped. The schema has 40000 objects.

    Which is the best possible way to drop them fast?

    Last time when i did for 25000 objects it took 5hrs.
    Can you post object type wise the numbers?

    Tamil
    Reply With Quote Reply With Quote
  5. 11-03-2005, 03:48 PM #5
    dbasan's Avatar
    dbasan
    dbasan is offline Advisor
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by tamilselvan


    Can you post object type wise the numbers?

    Tamil
    What difference its going to make? anyhow you have it here:
    DATABASE LINK 6
    INDEX 16704
    SEQUENCE 1
    TABLE 14550
    VIEW 9789
    PROCEDURES 1
    "What is past is PROLOGUE"
    Reply With Quote Reply With Quote
  6. 11-03-2005, 05:58 PM #6
    stecal's Avatar
    stecal
    stecal is offline Senior Advisor
    Join Date
    May 2002
    Posts
    2,645
    What difference? Maybe you could run a script that truncates all of that user's tables (no logging involved). How hard would it be to move everything into one tablespace?
    Reply With Quote Reply With Quote
  7. 11-04-2005, 11:20 AM #7
    dbasan's Avatar
    dbasan
    dbasan is offline Advisor
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by stecal
    What difference? Maybe you could run a script that truncates all of that user's tables (no logging involved). How hard would it be to move everything into one tablespace?

    Any how its going to take time to move, i can very well truncate/drop the objects then the user.
    "What is past is PROLOGUE"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width