all sys regenerate

[balla]

hi
j wanna regenerate all view and table of sys because j have imported in this user lot of tables by error.
J know it already exist a script for that comming with oracle.
Please can you give me this scriopt or any tip .
thanks

[Prasy]

u can run catalog.sql,catproc.sql to get basic system tables. If u run this the existing system tables will be dropped and new ones will be created.
apart from that there r many other sqls, which creates special purpose table,for ex tables for storing replication details.

[DBAtrix]

most of the sys objects that comprise the meta data for Oracle are created when you create your database (this uses sql.bsq file). catalog.sql will just recreate the data dictionary views (e.g. DBA_*, ALL_*, USER_*). no meta data segments will be dropped. catproc will just recreate procedures. none of these will have much affect on the storage in SYSTEM tablespace.

balla, i am not sure exactly what you did; do not confuse the owner SYSTEM with the tablespace SYSTEM (a storage area). if you mistakenly imported objects into the SYSTEM schema, you can find which object these are with
select owner, object_type, object_name
from dba_objects
where created > to_date( the time you began your import );

if you are very sure these are what you mistakenly imported, you can drop these objects. !!! take caution while doing this !!!

d.

[sreddy]

Make sure you run those scripts as SYS user.Otherwise there will be problems and conflicts.