Home » RDBMS Server » Server Utilities » When Importing data from Toad: Error: Out Of Memory - Very Urgent
When Importing data from Toad: Error: Out Of Memory - Very Urgent [message #154625] Mon, 09 January 2006 15:47 Go to next message
saritha_says
Messages: 12
Registered: October 2005
Location: Hydrabad
Junior Member

Hi,

I have created Oracle 8i on my machine(Win xp) and i am trying to load data from Toad(Database --> Import --> Table Data)into their respective tables, it was loading fine for a while, but now iam getting an error in Toad: Out Of Memory.

Below are the details i have done after installing the Oracle 8i.


create tablespace ss_data
datafile 'C:\oracle\oradata\oracle\ss\ss_data_1.dbf'
size 500m
autoextend on
next 100m maxsize 2000m
extent management local;

CREATE USER ss IDENTIFIED BY ss
DEFAULT TABLESPACE ss_DATA
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON ss_DATA
QUOTA UNLIMITED ON TEMP;

GRANT CREATE SESSION TO SS;

GRANT "RESOURCE" TO SS;
ALTER USER "SS" DEFAULT ROLE "RESOURCE";

Then i have started loading the Data into above ss schema.

My System Config:
2 GB RAM; 70GB and Win XP Pro.

Please help me in detail, It is Very Urgent...

Thanks for you time,
Saritha

Report message to a moderator

Re: When Importing data from Toad: Error: Out Of Memory - Very Urgent [message #155120 is a reply to message #154625] Thu, 12 January 2006 08:30 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Any errors in your database ALERT.LOG file?

Report message to a moderator

Previous Topic: SQL-Loader+ Big Problem
Next Topic: SQL Loader conditional statements?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 04:20:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.