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

Thread: Recreating the database

  1. 03-12-2001, 11:21 AM #1
    Hakimca
    Hakimca is offline Member
    Join Date
    Feb 2001
    Posts
    100
    Hi,

    I create a database with the default parameters. I have to recreate it to increase the DB_BLOC_SIZE. What the steps should I take before I recreate it and where can I find the script for that.

    Thanks
    Reply With Quote Reply With Quote
  2. 03-12-2001, 11:51 AM #2
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    One thing you can do if your database is not too big is create another database with different blocksize and export and import the existing database onto newly created database.
    Reddy,Sam
    Reply With Quote Reply With Quote
  3. 03-12-2001, 12:18 PM #3
    nalanda
    nalanda is offline Junior Member
    Join Date
    Oct 2000
    Posts
    25
    There is no way of changing the DB_BLOCK size once the database is created,
    You will have to recreate the database and do a FULL EXPORT and IMPORT the data into the new database.

    On command prompt
    >exp system/manager full=Y file=dba.dmp log=dba.log grants=Y rows=Y

    Only users with the DBA role or the EXP_FULL_DATABASE role can export in full database mode

    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