Exporting a database

[Ed75]

I'm fairly new to Oracle so if this is a stupid question be patient with me

What I'm trying to do it export a 9i database from an AIX enviroment to import to 9i on a windows platform.

What I've done in the past is just run exp and move the dmp file to the windows machine drop the sysadm user then import the file.

Today when trying to run exp I get the following error

EXP-00008: ORACLE error 1116 encountered
ORA-01116: error in opening database file 3
ORA-01110: data file 3: '/u03/oradata/HRPRD/psdefault.dbf'
ORA-27092: skgfofi: size of file exceeds file size limit of the process
Additional information: 131071
Additional information: 164225
EXP-00000: Export terminated unsuccessfully

Is there a better way to do what I'm trying to accomplish?

Ed

 

[DrD123]

Hi Ed,

On the AIX server from the same terminal you're trying the export from, can you run the following commands and post your results?:

ulimit -a

What you may need to do for the export sessions, is make your ulimit unlimited for filesize.

Good Luck
DrD

 

[Ed75]

time(seconds)        unlimited
file(blocks)         2097151
data(kbytes)         131072
stack(kbytes)        32768
memory(kbytes)       32768
coredump(blocks)     2097151
nofiles(descriptors) 2000

 

[KenCunningham]

Try setting your data(kbytes) setting to unlimited


I want to be good, is that not enough?

 

[DrD123]

Hi Ed,

You can raise the ulimit for your current dB export by:

ulimit -f unlimited
ulimit -d whatever_size_in_kb_it_needs_to_be

For global changes, you'll need sysadmin privileges



Good Luck
DrD

 

[Ed75]

Thanks...