手工重新创建8i数据库
作者:llmmysun
1.查看原来的数据库文件,保存其位置和大小
system
/home/ora817/oradata/clubcore/system01.dbf 800m
tools
/home/ora817/oradata/clubcore/tools01.dbf 250m
rbs
/home/ora817/oradata/clubcore/rbs01.dbf 1024m
temp
/home/ora817/oradata/clubcore/temp01.dbf 2048
users
/home2/ora817/oradata/clubcore/users01.dbf 2048
indx
/home3/ora817/oradata/clubcore/indx01.dbf 2048
club_core
/home2/ora817/oradata/clubcore/club_core01.dbf 2048
--查询原用户名,并导出原用户下数据
--2.查询数据库sid
oracle_sid=clubcore
--3.确定原表空间名称和大小
tablespace used mb
------------------------------------------------------------ ----------
free mb total
---------- ----------
club_core 0
2048 2048
indx 0
2048 2048
rbs 116
908 1024
tablespace used mb
------------------------------------------------------------ ----------
free mb total
---------- ----------
system 90
710 800
temp 0
2048 2048
tools 0
250 250
tablespace used mb
