{"id":158,"date":"2008-10-01T22:03:00","date_gmt":"2008-10-01T20:03:00","guid":{"rendered":"http:\/\/antynet.pl\/index.php\/2008\/10\/01\/oracle-datafiles\/"},"modified":"2010-08-24T22:44:59","modified_gmt":"2010-08-24T20:44:59","slug":"oracle-datafiles","status":"publish","type":"post","link":"https:\/\/www.antynet.pl\/index.php\/2008\/10\/01\/oracle-datafiles\/","title":{"rendered":"ORACLE DATAFILES"},"content":{"rendered":"<p><span style=\"font-family: arial; font-weight: bold;\">management:<\/span><br \/><span style=\"font-family: arial;\">ALTER TABLESPACE '[ts_name]&#8217; ADD DATAFILE '[file_path]&#8217; SIZE [size]G;<\/span><br \/><span style=\"font-family: arial;\">ALTER DATABASE DATAFILE '[file_path]&#8217; RESIZE [new_size]G;<\/span><br \/><span style=\"font-family: arial;\">ALTER DATABASE DATAFILE '[file_path]&#8217; AUTOEXTEND OFF | ON NEXT [size]M MAXSIZE [size]G;<\/span><br \/><b><span style=\"font-family: arial;\">change mode<\/span>:<\/b><br \/><span style=\"font-family: arial; font-weight: bold;\"> <\/span><span style=\"font-family: arial;\">ALTER DATABASE DATAFILE ONLINE|OFFLINE;<\/p>\n<p><\/span><span style=\"font-weight: bold;\">copy file:<\/span><\/p>\n<p><span style=\"font-family: arial; font-weight: bold;\">change file name <\/span><span style=\"font-family: arial;\"><span style=\"font-style: italic;\">(for datafiles,redologs,tempfiles,undo)<\/span><\/span><span style=\"font-family: arial; font-weight: bold;\">:<\/span><br \/><span style=\"font-family: arial;\">ALTER DATABASE RENAME FILE '[file]&#8217; TO '[file]&#8217;;<\/span><br \/><span style=\"font-style: italic;\">! 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)<\/span><br \/><span style=\"font-family: arial; font-weight: bold;\"><br \/>jezeli chodzi o controlfile to zmiany w pfile lub spfile <\/span><span style=\"font-family: arial;\"><span style=\"font-style: italic;\">(if you change controlfile path in PFILE remember about brackets &#8211; ORA-00205,<\/span><\/span><br \/><span style=\"font-family: arial;\"><span style=\"font-style: italic;\">copying controlfiles only if database is shutdown)<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>management:ALTER TABLESPACE '[ts_name]&#8217; ADD DATAFILE '[file_path]&#8217; SIZE [size]G;ALTER DATABASE DATAFILE '[file_path]&#8217; RESIZE [new_size]G;ALTER DATABASE DATAFILE '[file_path]&#8217; 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]&#8217; TO '[file]&#8217;;! For many files, also for system ts files, it must be in MOUNT [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[80],"tags":[77],"class_list":["post-158","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-datafiles"],"_links":{"self":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/158","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/comments?post=158"}],"version-history":[{"count":1,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/158\/revisions"}],"predecessor-version":[{"id":215,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/158\/revisions\/215"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}