I am not too savvy in Oracle, and I have been trying to create a TABLESPACE, which keep on giving me an error message of invalid file name. Below is the syntax that I have used:
SQL> create Tablespace HRMT 2 datafile 3 size 4 ; size * ERROR at line 3: ORA-02236: invalid file name
My book and all websites that I have been to suggest that I specify the file path for the DATAFILE, and when I specify a path, I get another error message.
SQL> create tablespace vania 2 datafile 'home/oracle/hait/' 3 size 10M 4 ; create tablespace vania * ERROR at line 1: ORA-01119: error in creating database file 'home/oracle/hait/' ORA-27040: file create error, unable to create file Linux Error: 2: No such file or directory
Do I need to create the datafile first before I can create the TABLESPACE? Are there pre-existing datafiles in the database that I can use? What would be the proper syntax to create a tablespace and/or a datafile? How and where do I create a .dbf file to create the tablespace?