OraFAQ Forum: Server Administration » Fixing Fragmentation

Home » RDBMS Server » Server Administration » Fixing Fragmentation

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Fixing Fragmentation [message #110093]

Thu, 03 March 2005 08:11

setudunya
Messages: 6
Registered: March 2005
Location: Botswana

Junior Member

I was trying to fix fragmentation by doing the following steps.
1. making export of system
2.Dropeed all user tables and sequences
3. Import data from the last export

when Importing it failled saying object exisits and nothing happened to the system, what should I do to drop tables so that I can later create during import.I am running oracle 8i.

Report message to a moderator

Re: Fixing Fragmentation [message #110097 is a reply to message #110093]

Thu, 03 March 2005 08:47

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

To "fix" fragmentation the simplest solution is to move to a LMT( locally managed tablespace) from a DMT (dictionary mananged).

>>when Importing it failled saying object exisits and nothing happened to the system, what should I do to drop tables so that I can later create during import.I am running oracle 8i.

Please post the complete error message.
If it is reporting about a SYS object, it should be Ok.

Report message to a moderator

Re: Fixing Fragmentation [message #110112 is a reply to message #110097]

Thu, 03 March 2005 09:49

setudunya
Messages: 6
Registered: March 2005
Location: Botswana

Junior Member

The error message is not from The SYS objects its all the user tables, it fails to create any user tables from import because there weere not droped and the databse status is the same as before started the process.

Report message to a moderator

Re: Fixing Fragmentation [message #110118 is a reply to message #110112]

Thu, 03 March 2005 10:08

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

well,
If you have dropped the objects, it should not complain.
So unless you post some information (session log file, error messages, oracle version and OS ) and exact thingies you did, It is very hard to guess.

Report message to a moderator

Re: Fixing Fragmentation [message #110207 is a reply to message #110118]

Fri, 04 March 2005 02:33

setudunya
Messages: 6
Registered: March 2005
Location: Botswana

Junior Member

Thank you for your response, I think the whole procedure is okay, its only that I ran the commands when there were users in the machine, how do I make sure that no users are on the machine. I am suing Oracle 8i running on SunSolaries 5.8 platform.

Report message to a moderator

Re: Fixing Fragmentation [message #110219 is a reply to message #110093]

Fri, 04 March 2005 05:13

Frank
Messages: 7901
Registered: March 2000

Senior Member

Look in the docs to see how to restrict access.

hth

Report message to a moderator

Re: Fixing Fragmentation [message #110335 is a reply to message #110219]

Sat, 05 March 2005 23:46

oldboy
Messages: 9
Registered: March 2005
Location: Chongqing CHINA

Junior Member

please post your IMP description .

Report message to a moderator

Re: Fixing Fragmentation [message #110366 is a reply to message #110335]

Mon, 07 March 2005 01:08

setudunya
Messages: 6
Registered: March 2005
Location: Botswana

Junior Member

#*************************************************************************
# Script to import all its users from a full export file (compressed)
#*************************************************************************
#
# This is the compress filename without the .Z
filename=$1
userid=$2
rm -f $filename reorgimp.out
/etc/mknod $filename p
compress -dc $filename > $filename &
imp $userid file=$filename \
fromuser=stud,gen,person,place,asset,rpt,dbas,lib,finc,miss,card,kman,med, \
web,pcm,appl buffer=90960 commit=y \
>>reorgimp.out 2>&1
#
# Create public synonyms
#
sqlplus $userid \@createsynxx.sql
cat createsynxx.out >> reorgimp.out

Report message to a moderator

Previous Topic:	How to remove non_data_dictionary object from SYSTEM tablespace
Next Topic:	How to increase the tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 03:50:50 CST 2025