| export and import [message #149350] |
Thu, 01 December 2005 06:00  |
bsubbu
Messages: 42
Registered: November 2005
Location: Hyderabad
|
Member |
|
|
Hi,
i am having some problem with export and import across different platforms(windows and linux) both are having same oracle version..
(1) First what i have done is ..
I have exported scott schema objects in sales database
which is running on windows xp(9i). dump file is having character set ....WE8MSWIN1252....export client is using this charecter set..
(2) when i imported that dump file in to subbu's schema which is running on linux machine....
character set is different..that is US7ASCII....
import was not done successfully.....i think problem with charecter set....import client is using US7ASCII CHARECTER SET...
can anybody help me how to conver the character set of that dump file into US7ASCII....
THANKS IN ADVACNE
SUBBU
[Updated on: Thu, 01 December 2005 06:10] Report message to a moderator |
|
|
|
|
|
| Re: export and import [message #149362 is a reply to message #149350] |
Thu, 01 December 2005 06:13  |
bsubbu
Messages: 42
Registered: November 2005
Location: Hyderabad
|
Member |
|
|
hi mahesh,
here i am giving the snashot of import...
can u please go through it..
[hanu@oralinux9 hanu]$ imp subbu/subbu_123 file=sd.dmp
Import: Release 9.2.0.1.0 - Production on Thu Dec 1 17:21:04 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export file created by EXPORT:V09.00.01 via conventional path
Warning: the objects were exported by SCOTT, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
export client uses WE8MSWIN1252 character set (possible charset conversion)
. importing SCOTT's objects into SUBBU
Import terminated successfully without warnings.
even it is showing the success..but i am not getting the tables which are imported..
regards
subbu
[Updated on: Thu, 01 December 2005 06:15] Report message to a moderator |
|
|
|
|
|
| Re: export and import [message #149376 is a reply to message #149371] |
Thu, 01 December 2005 06:54 |
bsubbu
Messages: 42
Registered: November 2005
Location: Hyderabad
|
Member |
|
|
mahesh,
here i am giving the export log
Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'SYS.LT_EXPORT_PKG' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
. exporting foreign function library names for user SCOTT
. 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 BONUS 0 rows exported
. . exporting table DEPT 4 rows exported
. . exporting table EMP 14 rows exported
. . exporting table SALGRADE 5 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
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'SYS.LT_EXPORT_PKG' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
. exporting statistics
Export terminated successfully with warnings.
thanks and regards
subbu
[Updated on: Thu, 01 December 2005 07:11] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: export and import [message #149457 is a reply to message #149350] |
Thu, 01 December 2005 22:00 |
bsubbu
Messages: 42
Registered: November 2005
Location: Hyderabad
|
Member |
|
|
Hi Mahesh,
ohh, yes mahesh...both database versions are different..
what i have done is
(1)windows machine=>>>>>9.0.1.1.1...
on windows machine i exported the scott's schema objects in to a dump file...and i ftp that file to linux machine
(2)linux machine=>>>>9.2.0.1.0....
i was improting the scott's schemas objects into subbu's schemas objects in linux machine using that dumpfile....but in log it is showing the all objects rows were imported...
still not getting the records in subbu's schema..
what is the problem mahesh..
is the problem with different database versions or charecter set?
pls can u expalin i am new to DBA?
Thanks and regards
Subbu
|
|
|
|
| Re: export and import [message #149491 is a reply to message #149350] |
Fri, 02 December 2005 00:59 |
bsubbu
Messages: 42
Registered: November 2005
Location: Hyderabad
|
Member |
|
|
Mahesh,
Thanks for great Reply...
Ya I got it..
before i did not mention touser in imp command.
before....$imp subbu/subbu_123 file=sd.dmp log=sd.log fromuser=scott ..but i did not mention any touser option..
today i mentioned it is improting correctly....thanks for
response..
here i am giving the log
[hanu@oralinux9 hanu]$ imp subbu/subbu_123 file=sd.dmp log=sd.log fromuser=scott touser=subbu
Import: Release 9.2.0.1.0 - Production on Fri Dec 2 12:12:11 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export file created by EXPORT:V09.00.01 via conventional path
Warning: the objects were exported by SCOTT, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
export client uses WE8MSWIN1252 character set (possible charset conversion)
. . importing table "BONUS" 0 rows imported
. . importing table "DEPT" 4 rows imported
. . importing table "EMP" 14 rows imported
. . importing table "SALGRADE" 5 rows imported
About to enable constraints...
Import terminated successfully without warnings.
[hanu@oralinux9 hanu]$ exit
exit
SQL> conn subbu/subbu_123
Connected.
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BONUS TABLE
DEPT TABLE
EMP TABLE
S TABLE
SALGRADE TABLE
anway i have one basic doubt mahesh...
i imported the objects of 9.0.1.1.1 database version which is running on windows to schema of diffterent database of 9.2.0.1.0 on linux....?
charecter set is diffenet? how it was possible to import like this without upgradation?
this is the basic doubt? can u please update me?
thanks and regards
subbu
|
|
|
|
| Re: export and import [message #149574 is a reply to message #149491] |
Fri, 02 December 2005 06:02 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
export / import is logical. Not physical.
In most cases , oracle will take care of characterset conversions.
And between versions as long as you export plain/straitforward data, it is possible to do it directly ( even from 8i to 9i or 9i to 10g etc).
But some special features like intermedia should go through the proper upgrade prcocess.
THanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
