Dear all:
I had created a tablespace and a temp tablespace files for the new shema, but I am not sure if I import the schema to the new tablespace file or the default one. How could I check?
what is the command to change the tablespace file and when do I need change it?
thanks.
SQL> create temporary tablespace temp_demov tempfile '/u02/BIPLATFORM_DB/temp01.dbf' size 5m autoextend on;
create temporary tablespace temp_demov templfile '/u02/BIPLATFORM_DB/temp01.dbf' size 5m autoextend on
SQL> create tablespace TBS1 datafile '/u02/BIPLATFORM_DB/tbs01.dbf' size 5m autoextend on
2 ;
Tablespace created.
[obiee@elysium-d ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Tue Aug 12 14:24:00 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> create or replace directory datapumpdir as '/tmp';
Directory created.
SQL> impdp system/arg0s@rhea directory=datapumpdir dumpfile=BISAMPLE.dmp logifle=BISAMPLE.log
SP2-0734: unknown command beginning "impdp syst..." - rest of line ignored.
SQL> impdp system/arg0s@rhea directory=datapumpdir dumpfile=BISAMPLE.dmp logifle=BISAMPLE.log
SP2-0734: unknown command beginning "impdp syst..." - rest of line ignored.
SQL>
[obiee@elysium-d ~]$ impdp system/arg0s@rhea directory=datapumpdir dumpfile=BISAMPLE.DMP logfile=BISAMPLE.log
Import: Release 11.2.0.2.0 - Production on Tue Aug 12 14:49:38 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
....