0
I’m having a hard time, I have my local bank, oracle XE, I’m adding a backup of the database I received, I made the following settings described, after finishing the bank’s Restore successfully, I made a connection to this database on my localhost using the user and password created earlier, no more and viewed any table?
--criando uma tablespace
--------------------------------------------------------------------------
CREATE TABLESPACE ATLASCARGOHBSAETC LOGGING DATAFILE 'C:/oraclexe/app/oracle/oradata/XE/ATLASCARGOHBSAETC.dbf'
SIZE 100m AUTOEXTEND ON NEXT 100m EXTENT MANAGEMENT LOCAL;
Resultado = OK
----------------------------------------------------------------------------
--criamos um usuário no Oracle e vincular este usuário ao tablespace chamada ATLASCARGOHBSAETC.
CREATE USER us_atlascargohbsaetc IDENTIFIED BY 123 DEFAULT TABLESPACE ATLASCARGOHBSAETC
QUOTA UNLIMITED ON ATLASCARGOHBSAETC;
Resultado = OK
----------------------------------------------------------------------------
--grant para o usuário logar e abrir uma sessão
GRANT CREATE SESSION TO us_atlascargohbsaetc;
Resultado = OK
----------------------------------------------------------------------------
--recuperar backup
impdp \"/ as sysdba\" DIRECTORY= DATA_PUMP_DIR DUMPFILE=HBSA_ETC
----------------------------------------------------------------------------