| Do I need to run catalog.sql and catproc.sql when I recreate a database [message #61228] |
Tue, 06 April 2004 06:31  |
Mark Savery
Messages: 12
Registered: May 2002
|
Junior Member |
|
|
I will need to resize our database due to someone setting up a user which used the system tablespace for temporary workspace. I took care of that problem, but ended up with a large system tablespace which I want to bring down to an appropriate level, freeing up diskspace for other things we want to do. We are running 8i and have run several tests on our test system to make sure that I can minimize the time we will need our production side down. The process I am doing to recreate the database is as follows.
1. Cold Backup
2. Full export of the database.
3. Drop the data files.
4. Recreate the database.
5. Run catalog.sql and catproc.sql
6. Import the data from the export in step 2
7. Turn on archive logs.
8. Another backup.
The question I have is, is it necessary to run catalog.sql and catproc.sql if I have performed a complete export?
|
|
|
|
|
|
|
|
| Re: Do I need to run catalog.sql and catproc.sql when I recreate a database [message #61232 is a reply to message #61230] |
Tue, 06 April 2004 08:46  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
If those ,that are present at the end of the tablespace are system objects, then your only *safe* option is to recreate the database as you outlined before.
I tend to like precreating the database and tablespaces(if havent considered locally managed already,this is your chance),run the necessary catalog scripts and import the schemas.
-Thiru
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
