YW
发帖数: 46 | 1 Hi Friends,
I am a new DBA wondering if somebody can help me on the following questions.
I am using Oracle 11g. I created a new database in the server, and I used
dbconsole to create the tablespace for this new database. it turns out that
the tablespace connected to the existing database instead of the new
database.
1. What steps or settings did I miss when using dbconsole?
2. Should I use Create tabalespace command instead of dbconsole, since it's
easy to controll?
3. Since I have to drop the tablespace, what is the saftest way to drop it?
plese provide the command if available.
Thanks in advance | c*****d
发帖数: 6045 | 2 1. 如果是在windows上的db console，需要在注册表修改oracle_sid
2. 我基本不用图形界面，用command更方便快捷
3. 在sqlplus里运行drop tablespace tablespace_name;
如果tablespace里已经存在segment，并且你确认这些table没用，可以用drop
tablespace tablespace_name including contents | YW
发帖数: 46 | 3 Dear Coolbid,
Thank you very much for your response. Now I know what I did wrong was when
I opened dbconsole to create tablespace, I used the original database URL,
in https//hostname:XXXX/em ( I believe this is called 注册表 in Chinese,
right?), the XXXX number is for original dabase, so it points to the orginal
database. I fixed it to delete the tablespace created in original database,
then recreated it in new database. It should be fine now. I don't have tool
setup yet, so can't use command at this time.
Really appreciate your help :) |
|
