Recreating the database Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Recreating the database

  1. #1
    Join Date
    Feb 2001

    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.


  2. #2
    Join Date
    Feb 2000
    Washington DC
    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.

  3. #3
    Join Date
    Oct 2000
    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

Posting Permissions

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

Click Here to Expand Forum to Full Width