problème accès en mode open après suppression des tablespaces

Puisque tu as supprimé ces tablespaces, je présume que tu n'en as plus besoin.
Je te propose ce petit mode d'emploi :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
SQL> startup
ORACLE instance started.
 
Total System Global Area 1476395008 bytes
Fixed Size                  2084072 bytes
Variable Size             620757784 bytes
Database Buffers          838860800 bytes
Redo Buffers               14692352 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01110: data file 10: '/data/ora/ORCL/test_01.dbf'
 
 
SQL> alter database datafile '/data/ora/ORCL/test_01.dbf' offline drop;
 
Database altered.
 
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01110: data file 11: '/data/ora/ORCL/test_02.dbf'
 
 
SQL> alter database datafile '/data/ora/ORCL/test_02.dbf' offline drop;
 
Database altered.
 
SQL> alter database open;
 
Database altered.
 
SQL> select file_name, tablespace_name from dba_data_files;
FILE_NAME                                                              TABLESPACE_NAME
---------------------------------------------------------------------- ------------------------------
....
/data/ora/ORCL/test_01.dbf                                          TEST
/data/ora/ORCL/test_02.dbf                                          TEST
 
SQL> drop tablespace test;
 
Tablespace dropped.

Rachid A.