| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Increasing DBS filesize while importing
Jennifer Hopeman wrote:
>
> I have a question about increasing the size of a DBS file
> when importing. I am importing with the DESTROY option
> equal to Y. I am trying to import into a DBS file that
> has the same name as the one exported from but a different
> size. I get the Oracle error ORA-07517 which basically is
> complaining that the destination file size is different from
> from the source. This error is in the VMS-specific portion of the
> error manual.
> ...
> Bill
Bill/Jennifer,
I think that destroy=y expects the filesize in the dump file to be the same size as the os datafile. The way to do this is to create the empty tablespace with the desired size, then just "imp destroy=n ignore=y" . The import then generates an error because the tablespace's datafiles already exsit, but happily ignores it and continues importing your data. Just be sure that ignore=y won't have any other side effects on what you're trying to accomplish with the import.
 |
 |