Home » RDBMS Server » Server Utilities » Not import the file
Not import the file [message #211046] Mon, 25 December 2006 21:05 Go to next message
sagi
Messages: 6
Registered: December 2006
Location: RAIPUR
Junior Member
Sir
I have a data base of around 200 files and I reqularly export it using the export with full user option. The entire database containing one partition table ( Table partition on the basis of date field in it) . While importing the date to a new database all tables where imported except the TABLE which has the partition.

Whow can i solve the problem . Please guide me


Re: Not import the file [message #211047 is a reply to message #211046] Mon, 25 December 2006 21:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> except the TABLE which has the partition.
How exactly?
Show us what you have done. Post the exact error message.
May be you are missing the tablespaces required for the partition. It could be anything.
  1  create table mytable
  2  (c1 number,c2 varchar2(100))
  3  partition by range (c1)
  4  (partition p1 values less than (10000),
  5* partition p2 values less than (20000))
scott@9i > /

Table created.
scott@9i > insert into mytable (select rownum c1,dbms_random.string('A',10) C2 FROM DUAL connect by level <=19999);

19999 rows created.

scott@9i > commit;

Commit complete.
 
scott@9i > !exp scott/tiger owner=scott

Export: Release 9.2.0.7.0 - Production on Mon Dec 25 22:30:25 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.7.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT
About to export SCOTT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SCOTT's tables via Conventional Path ...
. . exporting table                        MYTABLE
. . exporting partition                             P1       9999 rows exported
. . exporting partition                             P2      10000 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.


scott@9i > drop table mytable;

Table dropped.

scott@9i > !imp scott/tiger fromuser=scott touser=scott

Import: Release 9.2.0.7.0 - Production on Mon Dec 25 22:31:10 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.7.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. . importing partition                 "MYTABLE":"P1"       9999 rows imported
. . importing partition                 "MYTABLE":"P2"      10000 rows imported
Import terminated successfully without warnings.



[Updated on: Mon, 25 December 2006 21:30]

Report message to a moderator

Re: Not import the file [message #211077 is a reply to message #211047] Tue, 26 December 2006 02:45 Go to previous messageGo to next message
sagi
Messages: 6
Registered: December 2006
Location: RAIPUR
Junior Member
First of all thank you for the replay.
Sir but it is not working
scott@9i > !exp scott/tiger owner=scott
The abobe command is not taking from the sql prompt. When i go to the exp command through the command prompt it popup but that also ot give the desired result.

I am using oracle 9i in windows 2003

What should be the problem

Guide me

Re: Not import the file [message #211079 is a reply to message #211077] Tue, 26 December 2006 02:53 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Mahesh using "*nix" platform.
you can used "host" command. on sqlprompt.
like
SQL>HOST EXP scott/tiger OWNER=scott FILE=d:\scott.dmp LOG=d:\scott.log

When i go to the exp command through the command prompt it popup but that also ot give the desired result.

can you plz post your log file.

regards
Taj

[Updated on: Tue, 26 December 2006 02:54]

Report message to a moderator

Re: Not import the file [message #211089 is a reply to message #211077] Tue, 26 December 2006 04:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> The abobe command is not taking from the sql prompt
Adobe command?
Re: Not import the file [message #211120 is a reply to message #211089] Tue, 26 December 2006 08:26 Go to previous messageGo to next message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
Sometime misspelled words have the side effect of spelling other valid words, and other "computer" related words at that. Hahaha. I think he meant above.
Re: Not import the file [message #211126 is a reply to message #211120] Tue, 26 December 2006 09:41 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Smile
Previous Topic: FIELDS TERMINATED BY ","; NEED MISS "\," simboll
Next Topic: Sql Loader
Goto Forum:
  


Current Time: Wed Dec 07 02:55:00 CST 2016

Total time taken to generate the page: 0.07590 seconds