Create Table space, user, resize, and move data files

2 logging
3 datafile '/opt/oracle/oradata/bisal/test_data_01.dbf'
4 size 10 M
5 autoextend on
6 next 10 m maxsize 2000 m
7 extent management local;
Tablespace created.

Total 1.5 GB
-Rw-r ----- 1 oracle oinstall 11 M Sep 27 22: 56 test_data_01.dbf

2 default tablespace test_data
3 temporary tablespace tempts1;
User created.

USERNAME
------------------------------
TEST_DATA

Database altered.

Total 1.5 GB
-Rw-r ----- 1 oracle oinstall 26 M Sep 27 23:01 test_data_01.dbf

Tablespace altered.

Total 1.5 GB
-Rw-r ----- 1 oracle oinstall 26 M Sep 27 23:01 test_data_01.dbf
-Rw-r ----- 1 oracle oinstall 3.1 M Sep 27 test_data_02.dbf

:

SQL * Plus: Release 10.2.0.1.0-Production on Fri Sep 27 23:40:23 2013
Copyright (c) 1982,200 5, Oracle. All rights reserved.
ERROR:
ORA-01045: user TEST_DATA lacks create session privilege; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: ERROR:
ORA-01017: invalid username/password; logon denied

:

Create table test (x int)
*
ERROR at line 1:
ORA-01031: insufficient privileges

Grant succeeded.

:

Create table test (x int)
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'test _ data'

:

Create table test (x int)
*
ERROR at line 1:
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/opt/oracle/oradata/bisal/test_data_02.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3

Table created.