Home » RDBMS Server » Server Utilities » Problem: Import Bulk database in 8i to 10g
icon2.gif  Problem: Import Bulk database in 8i to 10g [message #299972] Wed, 13 February 2008 22:06 Go to next message
hb_venkatesh
Messages: 9
Registered: October 2007
Location: india
Junior Member

Hi,
I'm trying to import from oracle 8.1.7 database to oracle 10g
using command as
imp system/password@ora file= bacup.dmp full=y ignore=y log=anyfile.log
But it can start to import perfectly, but unfortunately it will
idle after some importing records. After it cannot take any
action.

Also oracle 10g cannot open after this action
because it display the tablespace memory is full.


please suggest to me to solve this problem

venki
Re: Problem: Import Bulk database in 8i to 10g [message #299994 is a reply to message #299972] Wed, 13 February 2008 23:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Always please post what you did, logfiles and errors you got.Verbatim.
Explaining what you did helps us very little.
>>because it display the tablespace memory is full.
May be you are just filling up the space. May be you need to increase the tablespace in target 10g database.


Re: Problem: Import Bulk database in 8i to 10g [message #300013 is a reply to message #299994] Thu, 14 February 2008 00:37 Go to previous messageGo to next message
hb_venkatesh
Messages: 9
Registered: October 2007
Location: india
Junior Member

Here there is no error in my log file and also no problem for import command i think , but the problem is that importing data are stop idle after some imported datas, but it could not import completely.

The dump file around 2GB
Please tell me why it became idel when importing data , how can
we overcome this problem.
I cont able to give any example file.

venki
Re: Problem: Import Bulk database in 8i to 10g [message #300023 is a reply to message #300013] Thu, 14 February 2008 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Are you sure it is idle? How did you check this?
2/ Post the first and last 10 lines of log file.
Before read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Use the "Preview Message" button to verify.

Regards
Michel

[Updated on: Thu, 14 February 2008 01:24]

Report message to a moderator

Re: Problem: Import Bulk database in 8i to 10g [message #300030 is a reply to message #300013] Thu, 14 February 2008 01:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Again,
Do not explain what you did.
Just post what you did. Post the logfile as Michel suggested.
Re: Problem: Import Bulk database in 8i to 10g [message #300049 is a reply to message #300023] Thu, 14 February 2008 01:53 Go to previous messageGo to next message
hb_venkatesh
Messages: 9
Registered: October 2007
Location: india
Junior Member

Ok Michel,
This is the report of my log file
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V08.01.06 via conventional path
import done in WE8ISO8859P1 character set and UTF8 NCHAR character set
export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)
. importing SYSTEM's objects into SYSTEM
 "ALTER SCHEMA = "SYSTEM""
 "CREATE TABLESPACE "RBS" DATAFILE  'D:\ORACLE\ORADATA\ORA\RBS01.DBF' SIZE 50"
 "3316480       AUTOEXTEND ON NEXT 5242880  MAXSIZE 4095M DEFAULT  STORAGE(IN"
 "ITIAL 524288 NEXT 524288 MINEXTENTS 8 MAXEXTENTS 4096 PCTINCREASE 50) ONLIN"
 "E PERMANENT ".................
.......................
 "CREATE TABLE "INVOICE" ("DEPOT_CODE" NUMBER(2, 0), "INVOICE_NO" NUMBER(6, 0"
 "), "INVOICE_DATE" DATE, "CUSTOMER_CODE" VARCHAR2(6), "CONSIGNEE_CODE" NUMBE"
 "R(2, 0), "ORDER_NO" NUMBER(6, 0) NOT NULL ENABLE, "QUANTITY" NUMBER(8, 3) N"
 "OT NULL ENABLE, "BASIC_AMOUNT" NUMBER(12, 2) NOT NULL ENABLE, "EXCISE_DUTY""
 " NUMBER(11, 2), "SALES_TAX" NUMBER(11, 2), "SURCHARGE_ON_STAX" NUMBER(10, 2"
 "), "FREIGHT_AMOUNT_FOR" NUMBER(11, 2), "INVOICE_AMOUNT" NUMBER(12, 2) NOT N"
 "ULL ENABLE, "ROUNDING_PAISE" NUMBER(5, 2), "FREIGHT_AMOUNT" NUMBER(11, 2), "
 ""CLASSIFICATION" VARCHAR2(1), "EXWORKS_FOR_TAG" VARCHAR2(1), "SALE_TAX_CODE"
 "" NUMBER(2, 0), "PRODUCT_CODE" NUMBER(2, 0), "CMA_RATE" NUMBER(5, 2), "RATE"
 "" NUMBER(5, 2), "REALISATION_AMOUNT" NUMBER(12, 2), "POSTING_TO_FA" VARCHAR"
 "2(1), "VOUCHER_NO" VARCHAR2(10), "VOUCHER_DATE" DATE, "CREATED_BY" VARCHAR2"
 "(8), "CREATED_DATE" DATE, "STATE_CODE" NUMBER(2, 0), "DISTRICT_CODE" NUMBER"
 "(2, 0), "TOWN_CODE" NUMBER(4, 0), "CESS_ON_ED" NUMBER(7, 2))  PCTFREE 10 PC"
 "TUSED 40 INITRANS 1 MAXTRANS 255 CACHE LOGGING STORAGE(INITIAL 59023360 NEX"
 "T 29491200 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1 FREELIST "
 "GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TBSCONSOLIDATION""


Up to this it can import after it goes idle..

venki

[Updated on: Thu, 14 February 2008 02:01] by Moderator

Report message to a moderator

Re: Problem: Import Bulk database in 8i to 10g [message #300051 is a reply to message #300049] Thu, 14 February 2008 02:03 Go to previous message
Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Format does not mean put in bold. Read the link I posted.
Once again, are you sure it is idle? How did you check this?

Possible verifications: v$lock, v$session_wait, activate a trace on import session to see what it is doing.

Regards
Michel
Previous Topic: Importing a schema from 9i to 10g using data pump import export + errors :(
Next Topic: Import
Goto Forum:
  


Current Time: Tue May 28 20:33:30 CDT 2024