management:
ALTER TABLESPACE '[ts_name]’ ADD DATAFILE '[file_path]’ SIZE [size]G;
ALTER DATABASE DATAFILE '[file_path]’ RESIZE [new_size]G;
ALTER DATABASE DATAFILE '[file_path]’ AUTOEXTEND OFF | ON NEXT [size]M MAXSIZE [size]G;
change mode:
ALTER DATABASE DATAFILE ONLINE|OFFLINE;
copy file:
change file name (for datafiles,redologs,tempfiles,undo):
ALTER DATABASE RENAME FILE '[file]’ TO '[file]’;
! For many files, also for system ts files, it must be in MOUNT mode, of course for one or two not system files it could be done by mode OFFLINE)
jezeli chodzi o controlfile to zmiany w pfile lub spfile (if you change controlfile path in PFILE remember about brackets – ORA-00205,
copying controlfiles only if database is shutdown)