File has an Oracle Managed Files file name. Advanced Search Forum Oracle Forums Oracle Database Administration importing to a different tablespace If this is your first visit, be sure to check out the FAQ by clicking the link above. However, how can you do the same when you cannot use Data Pump to perform Oracle import and export operations? I am new to oracle dba. https://asktom.oracle.com/pls/apex/f%3Fp%3D100:11:0::::P11_QUESTION_ID:66890284723848

importing MSC's objects into DBI . . How should we use the import in this case. exporting cluster definitions . How To Create Tablespace In Oracle 11g You can see that we have still have an error when importing the USER_DOCUMENTS table, but this time the error says "Tablespace USERS does not exist".

Followup June 22, 2010 - 7:45 am UTC please utilize support then, it should not be happening. Remap_tablespace In Imp So, either a) use a much faster set of tools - datapump expdp and impdp, they can remap tablespaces *easily* b) precreate these tables and use IGNORE=Y and wait a really All rows are created as a comment in the file. importing MSC's objects into DBI . .

exporting job queues .

Get 1:1 Help Now Advertise Here Enjoyed your answer?

For DDL with potentially multiple tablespace clauses (say, a partitioned table create as we have in our case) Oracle will give an ORA-00959.

It will be good if you create the tablespaces with the same size before you import any database 0 LVL 8 Overall: Level 8 Message Author Comment by:dba2dba2010-03-10 Thank you

If not, create it first. This rewritten CREATE succeeded. In my case, it is a brand new database with new schema and new tablespace. As the DBA, if you don't know them, who does? Imp-00017: Following Statement Failed With Oracle Error 942:

exporting posttables actions . I am trying to setuo daily exports of the database which can be imported during a disaster. Just make sure that the default tablespace is the one that you want to use. this contact form Oracle Database Advertise Here 776 members asked questions and received personalized solutions in the past 7 days.

Next Topic: Urgent. Imp-00058: Oracle Error 1950 Encountered Results 1 to 8 of 8 Thread: importing to a different tablespace Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Built with love using Oracle Application Express 5.

You can get the DDL for the table - with the old tablespace - by running imp with indexfile=. Solved Oracle Full Import Error Posted on 2010-03-05 Oracle Database 1 Verified Solution 16 Comments 2,844 Views Last Modified: 2012-06-27 Oracle 10g on Win 2003 Server I got the below errors The inconvenience is that several manual steps are involved in this workaround - the solution is described below. 1) Generate the SQL file [email protected]:/u00/app/oracle/admin/DB11G/dpdump/ [DB11G] imp system/Passw0rd file=exp_MSC.dmp log=imp_to_DBI.log fromuser=msc touser=dbi exporting job queues .

How to draw a horizontal rule with a colour gradient? This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher. �� BurlesonOracle Press authorAuthor of Oracle Tuning: The Definitive Reference « Next Oldest · Oracle Forum · Next Newest » 1 User(s) are reading this topic (1 Guests and 0 [email protected]> alter user tkyte default tablespace exp_test 2 / User altered.