ALTERAR DOMÍNIO WORDPRESS

UPDATE wp_options SET option_value = replace(option_value, 'http://SiteAtual.com.br/', 'http://novaurl/') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://SiteAtual.com.br/','http://novaurl/');

UPDATE wp_posts SET post_content = replace(post_content, 'http://SiteAtual.com.br/', 'http://novaurl/');

UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://SiteAtual.com.br/', 'http://novaurl/');

CRIAR TABLESPACE E USUÁRIO ORACLE 10G

CREATE TABLESPACE meutablespace LOGGING DATAFILE ‘/oracle10/oradata/minhabase/meutablespace.dbf‘ SIZE 32m AUTOEXTEND ON NEXT 32m EXTENT MANAGEMENT LOCAL;


CREATE USER meuusuario IDENTIFIED BY minhasenha DEFAULT TABLESPACE MEUTABLESPACE QUOTA UNLIMITED ON  MEUTABLESPACE;

GRANT create session, alter session, select_catalog_role, execute_catalog_role, create table, create procedure, create view, create materialized view, create trigger, create sequence, create any directory, create type, create synonym, administer database trigger TO meuusuario;