Bonjour,
j'essaie de créer une base mais :
et ensuite :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13 CREATE DATABASE ALDB2 AUTOMATIC STORAGE NO ON 'E:\' ALIAS ALDB2 USING CODESET IBM-1252 TERRITORY FR COLLATE USING SYSTEM PAGESIZE 4096 CATALOG TABLESPACE MANAGED BY SYSTEM USING ( 'E:\bases\ALDB2' ) USER TABLESPACE MANAGED BY SYSTEM USING ( 'E:\bases\ALDB2' ) TEMPORARY TABLESPACE MANAGED BY SYSTEM USING ( 'E:\bases\ALDB2' ) SQL1005N The database alias "ALDB2" already exists in either the local database directory or system database directory. .............. ............... User response: * Drop the database using the alias name. Resubmit your original command. * Uncatalog the alias. Resubmit your original command. * Catalog the alias into the system database directory. Drop the database using the same alias. Resubmit your original command.
Que dois-je faire et comment fair :Catalog the alias into the system database directory .
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12 uncatalog database ALDB2; ------------------------------------------------------------------------------ uncatalog database ALDB2 SQL1013N The database alias name or database name "ALDB2" could not be found. SQLSTATE=42705 DROP database ALDB2; ------------------------------------------------------------------------------ DROP database ALDB2 SQL1013N The database alias name or database name "ALDB2 " could not be found. SQLSTATE=42705
Merci d'avance pour votre aide.
Partager