Step1:Create tablespace and Expdp: SQL> select table_name,tablespace_name from dba_tables where table_name=’BK’; TABLE_NAME ——————————————————————————– TABLESPACE_NAME —————————— BK INBA SQL> select name from v$datafile; NAME ——————————————————————————– /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_h1lpjm44_.dbf /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_h1lpl0nb_.dbf /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_h1lplsxv_.dbf /u01/app/oracle/oradata/ORCL/datafile/inba01.dbf /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_h1lplv5f_.dbf SQL> alter user remo default tablespace inba; User altered. SQL> conn remo/remo Connected. SQL> select * from bb; ID ———- 22 23 […]
Read More