Re: import to database

Posted by Roshan on Oct 25, 2016; 10:02am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/import-to-database-tp1433p1435.html

I extended the datafile as shown below for the table:
SQL> SELECT tablespace_name
  FROM dba_tables
WHERE table_name =  2    3
  4  'SEGMENT_BCKUP';

TABLESPACE_NAME
------------------------------
USERS

SQL> select file_name,bytes/1024/1024 from dba_data_files where tablespace_name='USERS';

FILE_NAME
--------------------------------------------------------------------------------
BYTES/1024/1024
---------------
/u02/recondb/oradata/recondb/users01.dbf
            135


SQL> alter database datafile '/u02/recondb/oradata/recondb/users01.dbf' resize 4g;

Database altered.