Home » RDBMS Server » Server Utilities » How to create a datafile with 4GB+
How to create a datafile with 4GB+ [message #71570] Sun, 24 November 2002 20:51 Go to next message
iamseaver
Messages: 6
Registered: November 2002
Junior Member
Enviroment: Win2000, Oracle8.0.5

Report message to a moderator

Re: How to create a datafile with 4GB+ [message #71574 is a reply to message #71570] Mon, 25 November 2002 03:49 Go to previous messageGo to next message
B
Messages: 327
Registered: August 1999
Senior Member
why ????

it's very BAD ! create two 2GB datafile instead...

Report message to a moderator

Re: How to create a datafile with 4GB+ [message #71577 is a reply to message #71574] Mon, 25 November 2002 06:57 Go to previous messageGo to next message
iamseaver
Messages: 6
Registered: November 2002
Junior Member
hello,B

I think now i must use a datafile with 4GB+. because I must use a dmp file produced by exp and I can not execute exp from source database. Now I only can use the existing exported dmp file. When i am tring importimg data from dmp file, ORA-02219 occurs because NEXT is too big. I think using a huge datafile should works. but i cannot in Oracle8.0.5

Report message to a moderator

Re: How to create a datafile with 4GB+ [message #71597 is a reply to message #71574] Wed, 27 November 2002 03:40 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
No i explain U already...

Next couldn't be > 2GB ... so export with COMPRESS=N

Always get ther error INVALID SIZE

No need datafile bigger then 2GB

Report message to a moderator

Previous Topic: is oracle running ?
Next Topic: dbms_pipe
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 22:35:09 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.