-
I'm trying to import data into a new database that has locally managed tablespaces. I'm trying to import for an export done from a database that does'nt have locally managed tablespaces. And I'm getting this error when it tries to create tha tables:
"unable to create INITIAL extent for segment in tablespace CI_DATA"
I understand the error but what I would like to know is how can I do an import in a db that has locally managed tablespaces, from an export that does'nt have these type of tablespace.
Thanks in advance.
-
This doesn't answer your question, but provides a solution.
1. imp system/manager file=xyz.dmp indexfile=xyz.sql
2. edit xyz.sql and take out all the storage clauses
3. run xyz.sql to pre-create your tables and indexes
4. imp system/manager file=xyz.dmp ignore=y
Jeff Hunter
-
You have to use show=y option in step1. Seems marist89 forgot to mention.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|