# # Show that datafiles are restricted to known directories. # Rules: # 1. Known Directories are the unique subsets from the combination of: # --datadir, --innobd-directories, --innodb-data-home-dir, --innodb-undo-directory # 2. If --innodb-undo-directory is unique, new IBD files are not allowed there. # 3. Any location referenced in DATA DIRECTORY must be a Known Directory other than a unique undo dir. # 4. CREATE TABLESPACE ... ADD DATAFILE must be a Known Directory other than a unique undo dir. # 5. CREATE UNDO TABLESPACE ... ADD DATAFILE must be any Known Directory. # 6. At startup, since previous engines did not restrict locations to known directories, # anything found will be used as before. But a warning message will be put into the error log. # SET default_storage_engine=InnoDB; # # Create a table in a known directory. # CREATE TABLE t1(c1 INT) DATA DIRECTORY='MYSQL_TMP_DIR/known_dir'; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci DATA DIRECTORY='MYSQL_TMP_DIR/known_dir/' # # Attempt to create a table in an unknown directory. # CREATE TABLE bad_1 (c1 INT) DATA DIRECTORY='MYSQL_TMP_DIR/unknown_dir'; ERROR HY000: The DATA DIRECTORY location must be in a known directory. SHOW WARNINGS; Level Code Message Error 3121 The DATA DIRECTORY location must be in a known directory. Error 1031 Table storage engine for 'bad_1' doesn't have this option # # Attempt to create a table in the datadir. # CREATE DATABASE data; USE data; CREATE TABLE bad_2 (c1 INT) DATA DIRECTORY='MYSQLTEST_VARDIR/mysqld.1'; ERROR HY000: The DATA DIRECTORY location cannot be the datadir. SHOW WARNINGS; Level Code Message Error 3121 The DATA DIRECTORY location cannot be the datadir. Error 1031 Table storage engine for 'bad_2' doesn't have this option USE test; DROP DATABASE data; # # Attempt to create a table in a unique undo directory. # CREATE TABLE bad_3 (c1 INT) DATA DIRECTORY='MYSQL_TMP_DIR/undo_dir'; ERROR HY000: The DATA DIRECTORY location cannot be the undo directory. SHOW WARNINGS; Level Code Message Error 3121 The DATA DIRECTORY location cannot be the undo directory. Error 1031 Table storage engine for 'bad_3' doesn't have this option # # Create a general tablespace in a known directories. # CREATE TABLESPACE ts1 ADD DATAFILE 'MYSQL_TMP_DIR/known_dir/ts1.ibd'; # # Attempt to create a general tablespace in an unknown directory. # CREATE TABLESPACE bad_4 ADD DATAFILE 'MYSQL_TMP_DIR/unknown_dir/bad_4.ibd'; ERROR HY000: The DATAFILE location must be in a known directory. SHOW WARNINGS; Level Code Message Error 3121 The DATAFILE location must be in a known directory. Error 1528 Failed to create TABLESPACE bad_4 Error 3121 Incorrect File Name 'MYSQL_TMP_DIR/unknown_dir/bad_4.ibd'. # # Attempt to create a general tablespace in a unique undo directory. # CREATE TABLESPACE bad_5 ADD DATAFILE 'MYSQL_TMP_DIR/undo_dir/bad_5.ibd'; ERROR HY000: The DATAFILE location cannot be the undo directory. SHOW WARNINGS; Level Code Message Error 3121 The DATAFILE location cannot be the undo directory. Error 1528 Failed to create TABLESPACE bad_5 Error 3121 Incorrect File Name 'MYSQL_TMP_DIR/undo_dir/bad_5.ibd'. # # Attempt to create a general tablespace in a subdirectory of the datadir. # CREATE TABLESPACE bad_6 ADD DATAFILE 'general/bad_6.ibd'; ERROR HY000: The DATAFILE location cannot be under the datadir. SHOW WARNINGS; Level Code Message Error 3121 The DATAFILE location cannot be under the datadir. Error 1528 Failed to create TABLESPACE bad_6 Error 3121 Incorrect File Name 'general/bad_6.ibd'. # # Create an undo tablespace in the unique undo directory. # CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'MYSQL_TMP_DIR/undo_dir/undo_003.ibu'; # # Create an undo tablespace in a known dir other than the unique undo directory. # CREATE UNDO TABLESPACE undo_004 ADD DATAFILE 'MYSQL_TMP_DIR/known_dir/undo_004.ibu'; SELECT NAME, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE = 'Undo' ORDER BY NAME; NAME SPACE_TYPE STATE innodb_undo_001 Undo active innodb_undo_002 Undo active undo_003 Undo active undo_004 Undo active # # Attempt to create an undo tablespace in an unknown directory. # CREATE UNDO TABLESPACE bad_7 ADD DATAFILE 'MYSQL_TMP_DIR/unknown_dir/bad_7.ibu'; ERROR HY000: The UNDO DATAFILE location must be in a known directory. SHOW WARNINGS; Level Code Message Error 3121 The UNDO DATAFILE location must be in a known directory. Error 1528 Failed to create UNDO TABLESPACE bad_7 Error 3121 Incorrect File Name 'MYSQL_TMP_DIR/unknown_dir/bad_7.ibu'. # # Create a table with a partitions in known directories. # CREATE TABLE tp1(c1 INT) PARTITION BY HASH(c1) ( PARTITION p1 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir', PARTITION p2 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir', PARTITION p3 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir'); SHOW CREATE TABLE tp1; Table Create Table tp1 CREATE TABLE `tp1` ( `c1` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!50100 PARTITION BY HASH (`c1`) (PARTITION p1 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB, PARTITION p2 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB, PARTITION p3 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB) */ # # Attempt to create a table with a partition in an unknown directory. # CREATE TABLE bad_8(c1 INT) PARTITION BY HASH(c1) ( PARTITION p1 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir', PARTITION p2 DATA DIRECTORY='MYSQL_TMP_DIR/unknown_dir', PARTITION p3 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir'); ERROR HY000: The DATA DIRECTORY location must be in a known directory. SHOW WARNINGS; Level Code Message Error 3121 The DATA DIRECTORY location must be in a known directory. Error 1031 Table storage engine for 'bad_8' doesn't have this option # # Attempt to create a table with a partition in the undo directory. # CREATE TABLE bad_9(c1 INT) PARTITION BY HASH(c1) ( PARTITION p1 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir', PARTITION p2 DATA DIRECTORY='MYSQL_TMP_DIR/undo_dir', PARTITION p3 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir'); ERROR HY000: The DATA DIRECTORY location cannot be the undo directory. SHOW WARNINGS; Level Code Message Error 3121 The DATA DIRECTORY location cannot be the undo directory. Error 1031 Table storage engine for 'bad_9' doesn't have this option # # Create a table with a sub-partitions in known directories. # CREATE TABLE tp3(c1 INT, c2 INT) PARTITION BY RANGE(c1) SUBPARTITION BY HASH(c2) ( PARTITION p1 VALUES LESS THAN (10) ( SUBPARTITION s1 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir', SUBPARTITION s2 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir'), PARTITION p2 VALUES LESS THAN (20) ( SUBPARTITION s3 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir', SUBPARTITION s4 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir')); SHOW CREATE TABLE tp3; Table Create Table tp3 CREATE TABLE `tp3` ( `c1` int DEFAULT NULL, `c2` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!50100 PARTITION BY RANGE (`c1`) SUBPARTITION BY HASH (`c2`) (PARTITION p1 VALUES LESS THAN (10) (SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB, SUBPARTITION s2 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB), PARTITION p2 VALUES LESS THAN (20) (SUBPARTITION s3 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB, SUBPARTITION s4 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB)) */ # # Attempt to create a table with a sub-partition in an unknown directory. # CREATE TABLE bad_10(c1 INT, c2 INT) PARTITION BY RANGE(c1) SUBPARTITION BY HASH(c2) ( PARTITION p1 VALUES LESS THAN (10) ( SUBPARTITION s1 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir', SUBPARTITION s2 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir'), PARTITION p2 VALUES LESS THAN (20) ( SUBPARTITION s3 DATA DIRECTORY='MYSQL_TMP_DIR/unknown_dir', SUBPARTITION s4 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir')); ERROR HY000: The DATA DIRECTORY location must be in a known directory. SHOW WARNINGS; Level Code Message Error 3121 The DATA DIRECTORY location must be in a known directory. Error 1031 Table storage engine for 'bad_10' doesn't have this option # # Attempt to create a table with a sub-partition in the undo directory # CREATE TABLE bad_11(c1 INT, c2 INT) PARTITION BY RANGE(c1) SUBPARTITION BY HASH(c2) ( PARTITION p1 VALUES LESS THAN (10) ( SUBPARTITION s1 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir', SUBPARTITION s2 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir'), PARTITION p2 VALUES LESS THAN (20) ( SUBPARTITION s3 DATA DIRECTORY='MYSQL_TMP_DIR/undo_dir', SUBPARTITION s4 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir')); ERROR HY000: The DATA DIRECTORY location cannot be the undo directory. SHOW WARNINGS; Level Code Message Error 3121 The DATA DIRECTORY location cannot be the undo directory. Error 1031 Table storage engine for 'bad_11' doesn't have this option # # Attempt to add a partition using an unknown directory. # ALTER TABLE tp3 ADD PARTITION ( PARTITION p3 VALUES LESS THAN (30) ( SUBPARTITION s5 DATA DIRECTORY 'MYSQL_TMP_DIR/known_dir', SUBPARTITION s6 DATA DIRECTORY 'MYSQL_TMP_DIR/unknown_dir')); ERROR HY000: The DATA DIRECTORY location must be in a known directory. SHOW WARNINGS; Level Code Message Error 3121 The DATA DIRECTORY location must be in a known directory. Error 1031 Table storage engine for 'tp3' doesn't have this option # # Successfully add a partition using a known directory. # ALTER TABLE tp3 ADD PARTITION ( PARTITION p3 VALUES LESS THAN (30) ( SUBPARTITION s5 DATA DIRECTORY 'MYSQL_TMP_DIR/known_dir', SUBPARTITION s6 DATA DIRECTORY 'MYSQL_TMP_DIR/known_dir')); SHOW CREATE TABLE tp3; Table Create Table tp3 CREATE TABLE `tp3` ( `c1` int DEFAULT NULL, `c2` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!50100 PARTITION BY RANGE (`c1`) SUBPARTITION BY HASH (`c2`) (PARTITION p1 VALUES LESS THAN (10) (SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB, SUBPARTITION s2 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB), PARTITION p2 VALUES LESS THAN (20) (SUBPARTITION s3 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB, SUBPARTITION s4 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB), PARTITION p3 VALUES LESS THAN (30) (SUBPARTITION s5 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB, SUBPARTITION s6 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB)) */ # # Attempt to reorganize a partition using an unknown directory. # ALTER TABLE tp3 REORGANIZE PARTITION p3 INTO ( PARTITION p3 VALUES LESS THAN(40) ( SUBPARTITION s5 DATA DIRECTORY 'MYSQL_TMP_DIR/unknown_dir', SUBPARTITION s6 DATA DIRECTORY 'MYSQL_TMP_DIR/known_dir')); ERROR HY000: The DATA DIRECTORY location must be in a known directory. SHOW WARNINGS; Level Code Message Error 3121 The DATA DIRECTORY location must be in a known directory. Error 1031 Table storage engine for 'tp3' doesn't have this option # # Show CREATE TABLE for all three tables. # SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci DATA DIRECTORY='MYSQL_TMP_DIR/known_dir/' SHOW CREATE TABLE tp1; Table Create Table tp1 CREATE TABLE `tp1` ( `c1` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!50100 PARTITION BY HASH (`c1`) (PARTITION p1 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB, PARTITION p2 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB, PARTITION p3 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB) */ SHOW CREATE TABLE tp3; Table Create Table tp3 CREATE TABLE `tp3` ( `c1` int DEFAULT NULL, `c2` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!50100 PARTITION BY RANGE (`c1`) SUBPARTITION BY HASH (`c2`) (PARTITION p1 VALUES LESS THAN (10) (SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB, SUBPARTITION s2 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB), PARTITION p2 VALUES LESS THAN (20) (SUBPARTITION s3 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB, SUBPARTITION s4 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB), PARTITION p3 VALUES LESS THAN (30) (SUBPARTITION s5 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB, SUBPARTITION s6 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB)) */ # # Show these tables in information_schema. # === information_schema.innodb_tables and innodb_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single test/t1 test/t1 97 4 Dynamic 0 Single test/tp1#p#p1 test/tp1#p#p1 97 4 Dynamic 0 Single test/tp1#p#p2 test/tp1#p#p2 97 4 Dynamic 0 Single test/tp1#p#p3 test/tp1#p#p3 97 4 Dynamic 0 Single test/tp3#p#p1#sp#s1 test/tp3#p#p1#sp#s1 97 5 Dynamic 0 Single test/tp3#p#p1#sp#s2 test/tp3#p#p1#sp#s2 97 5 Dynamic 0 Single test/tp3#p#p2#sp#s3 test/tp3#p#p2#sp#s3 97 5 Dynamic 0 Single test/tp3#p#p2#sp#s4 test/tp3#p#p2#sp#s4 97 5 Dynamic 0 Single test/tp3#p#p3#sp#s5 test/tp3#p#p3#sp#s5 97 5 Dynamic 0 Single test/tp3#p#p3#sp#s6 test/tp3#p#p3#sp#s6 97 5 Dynamic 0 Single === information_schema.innodb_tablespaces and innodb_datafiles === Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd test/t1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/t1.ibd test/tp1#p#p1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp1#p#p1.ibd test/tp1#p#p2 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp1#p#p2.ibd test/tp1#p#p3 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp1#p#p3.ibd test/tp3#p#p1#sp#s1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp3#p#p1#sp#s1.ibd test/tp3#p#p1#sp#s2 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp3#p#p1#sp#s2.ibd test/tp3#p#p2#sp#s3 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp3#p#p2#sp#s3.ibd test/tp3#p#p2#sp#s4 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp3#p#p2#sp#s4.ibd test/tp3#p#p3#sp#s5 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp3#p#p3#sp#s5.ibd test/tp3#p#p3#sp#s6 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp3#p#p3#sp#s6.ibd ts1 General DEFAULT 0 1 1 Any MYSQL_TMP_DIR/known_dir/ts1.ibd === information_schema.files === Space_Name File_Type Engine Status Tablespace_Name Path mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd test/t1 TABLESPACE InnoDB NORMAL test/t1 MYSQL_TMP_DIR/known_dir/test/t1.ibd test/tp1#p#p1 TABLESPACE InnoDB NORMAL test/tp1#p#p1 MYSQL_TMP_DIR/known_dir/test/tp1#p#p1.ibd test/tp1#p#p2 TABLESPACE InnoDB NORMAL test/tp1#p#p2 MYSQL_TMP_DIR/known_dir/test/tp1#p#p2.ibd test/tp1#p#p3 TABLESPACE InnoDB NORMAL test/tp1#p#p3 MYSQL_TMP_DIR/known_dir/test/tp1#p#p3.ibd test/tp3#p#p1#sp#s1 TABLESPACE InnoDB NORMAL test/tp3#p#p1#sp#s1 MYSQL_TMP_DIR/known_dir/test/tp3#p#p1#sp#s1.ibd test/tp3#p#p1#sp#s2 TABLESPACE InnoDB NORMAL test/tp3#p#p1#sp#s2 MYSQL_TMP_DIR/known_dir/test/tp3#p#p1#sp#s2.ibd test/tp3#p#p2#sp#s3 TABLESPACE InnoDB NORMAL test/tp3#p#p2#sp#s3 MYSQL_TMP_DIR/known_dir/test/tp3#p#p2#sp#s3.ibd test/tp3#p#p2#sp#s4 TABLESPACE InnoDB NORMAL test/tp3#p#p2#sp#s4 MYSQL_TMP_DIR/known_dir/test/tp3#p#p2#sp#s4.ibd test/tp3#p#p3#sp#s5 TABLESPACE InnoDB NORMAL test/tp3#p#p3#sp#s5 MYSQL_TMP_DIR/known_dir/test/tp3#p#p3#sp#s5.ibd test/tp3#p#p3#sp#s6 TABLESPACE InnoDB NORMAL test/tp3#p#p3#sp#s6 MYSQL_TMP_DIR/known_dir/test/tp3#p#p3#sp#s6.ibd ts1 TABLESPACE InnoDB NORMAL ts1 MYSQL_TMP_DIR/known_dir/ts1.ibd # # Validate the messages that should have been put into the error log. # Pattern "Cannot create a tablespace for table test/bad_1 because the directory is not a valid location. The DATA DIRECTORY location must be in a known directory" found Pattern "Cannot create a tablespace for table data/bad_2 because the directory is not a valid location. The DATA DIRECTORY location cannot be the datadir" found Pattern "Cannot create a tablespace for table test/bad_3 because the directory is not a valid location. The DATA DIRECTORY location cannot be the undo directory" found Pattern "Cannot create tablespace bad_4 because the directory is not a valid location. The DATAFILE location must be in a known directory" found Pattern "Cannot create tablespace bad_5 because the directory is not a valid location. The DATAFILE location cannot be the undo directory" found Pattern "Cannot create tablespace bad_6 because the directory is not a valid location. The DATAFILE location cannot be under the datadir" found Pattern "Cannot create tablespace bad_7 because the directory is not a valid location. The UNDO DATAFILE location must be in a known directory" found Pattern "Cannot create a tablespace for table test/bad_8.*p2 because the directory is not a valid location. The DATA DIRECTORY location must be in a known directory" found Pattern "Cannot create a tablespace for table test/bad_9.*p2 because the directory is not a valid location. The DATA DIRECTORY location cannot be the undo directory" found Pattern "Cannot create a tablespace for table test/bad_10.*p2.*s3 because the directory is not a valid location. The DATA DIRECTORY location must be in a known directory" found Pattern "Cannot create a tablespace for table test/bad_11.*p2.*s3 because the directory is not a valid location. The DATA DIRECTORY location cannot be the undo directory" found Pattern "Cannot create a tablespace for table test/tp3.*p3.*s6 because the directory is not a valid location. The DATA DIRECTORY location must be in a known directory" found Pattern "Cannot create a tablespace for table test/tp3.*p3.*s5#tmp because the directory is not a valid location. The DATA DIRECTORY location must be in a known directory" found # # Cleanup # DROP TABLE t1; DROP TABLE tp1; DROP TABLE tp3; DROP TABLESPACE ts1; ALTER UNDO TABLESPACE undo_003 SET INACTIVE; ALTER UNDO TABLESPACE undo_004 SET INACTIVE; DROP UNDO TABLESPACE undo_003; DROP UNDO TABLESPACE undo_004;