user3560681
user3560681

Reputation: 101

What if tablespace is not defined(PARTITION)

I create partition by list, but not define tablespaces for each PARTITION. What happens then?:

CREATE TABLE movie_genres (
    movie_genre_id INT NOT NULL,
    movie_id INT NOT NULL,
    genre_id INT NOT NULL,
    PRIMARY KEY (movie_genre_id),
    FOREIGN KEY (movie_id) REFERENCES movies(movie_id),
    FOREIGN KEY (genre_id) REFERENCES GENRES(genre_id),
    UNIQUE (movie_id, genre_id)
)
  PARTITION BY LIST(GENRE_ID)
  ( PARTITION Drama VALUES (8),
    PARTITION Comedy VALUES (5)
  );

Upvotes: 0

Views: 116

Answers (1)

travBoog
travBoog

Reputation: 73

Select def_tablespace_name from dba(all,user)_part_tables;

Upvotes: 1

Related Questions