Topic: Backup & Recovery >> Logical Backup
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| jothi |
Posted: Mar 17, 2008 10:46:02 PM |
Total Post: 26
Joined: Aug, 2007
|
Im trying to import a table with indexfile parameter and no matter
what I do, my table is skipped, but there are no errors
produced by imp, and there are also no errors in alert_SID.log and
SID_ora_*.trc.The command is used and the output is
C:\>imp 'sys/sys as sysdba' fromuser=sys touser=sys tables=emp indexes=y indexfile=c:\index.sql file='c:\file1.dmp'
Import: Release 9.2.0.1.0 - Production on Tue Mar 18 07:52:02 2008
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.02.00 via direct path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. . skipping table "EMP"
Import terminated successfully without warnings.
I used oracle 9i on windows.The index(index.sql) file has
REM CREATE TABLE "SYS"."EMP" ("NAME" VARCHAR2(20), "ID" NUMBER, "PHONE"
REM NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL
REM 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "RMAN" LOGGING
REM NOCOMPRESS ;
REM ... 50 rows
CONNECT SYS;
CREATE INDEX "SYS"."ID_IND" ON "EMP" ("ID" ) PCTFREE 10 INITRANS 2
MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1)
TABLESPACE "SYSTEM" LOGGING ;
Can anyone help me to solve this.
Thank you
|
|
|
 Murtuja |
| Posted: Mar 17, 2008 11:57:00 PM |  |
|
Total Post: 857
Joined: Jan, 2006
|
As per my blind guess touser=sys is creating problem.Try dofferent user in touser.
|
|
|
|
|
| Gitesh |
| Posted: Mar 18, 2008 08:16:23 AM | |
|
Total Post: 322
Joined: May, 2005
|
Dear,
While using indexfile parameter in IMPORT that time Oracle always create file for creating index commands. Oracle won't import any data in physical location.
Indexfile parameter is needed while we want to change tablespace name or change any storage parameters. After creating indexfile generally DBA can create empty tables in the schema with changing storage parameters and after that DBA will execute again import data with using IGNORE=Y parameter because physical table already exist.
I think you are now clear.
|
|
|
|
|
| jothi |
| Posted: Mar 18, 2008 01:18:58 PM | |
|
Total Post: 26
Joined: Aug, 2007
|
Yes.im clear now.Thank you
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
