cancel
Showing results for 
Search instead for 
Did you mean: 

Data base Control file not created

Former Member
0 Kudos

Dear ALL

We have refreshed data from Production system to Quality system, after that creating control file we will getting following below error, In that offline backup already restore DR prod system

We tried different successful backup from media

Please help me on this issue

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01200: actual file size of 32000 is smaller than correct size of 64000

blocks

ORA-01110: data file 2: 'G:\ORACLE\QK1\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

Regards

M.Karthik

+91 99401 87552

Accepted Solutions (1)

Accepted Solutions (1)

stefan_koehler
Active Contributor
0 Kudos

Hello Karthik,

i think there went something wrong by your restore / copy of the datafiles.

I think only the "half" of the file was copied / restored. Please check the file size on the OS.

Or maybe the file has been auto extended while the backup job was running.

Whats your oracle version?

Regards

Stefan

Former Member
0 Kudos

Hi Stephan

Already i have checked the Data file Size in source and target system it's 250 mb.

Please reply.

Regards

M.Karthik

Former Member
0 Kudos

Hi

Oracle version 10.2.0.1

Sapversion: R3 4.6 C

Regards

M.Karthik

stefan_koehler
Active Contributor
0 Kudos

Hello Karthik,

i think you got some file header corruption.

If you calculate the data file size by default (with db_block_size 8k) - you will get these:

32000 * 8 kb = 256000 kb = 250 M

64000 * 8 kb = 512000 kb = 500 M

To verify this, please dump the file headers and post the corresponding output of the datafile 2.

>sqlplus "/ as sysdba"

>SQL> oradebug SETMYPID

>SQL> oradebug dump file_hdrs 3

Regards

Stefan

Answers (1)

Answers (1)

former_member204746
Active Contributor
0 Kudos

please provide the "create control file" command you used.

check dates of each of your database files, they should be all the same.

Former Member
0 Kudos

Hi

CREATE CONTROLFILE SET DATABASE "QK1" RESETLOGS ARCHIVELOG

MAXLOGFILES 255

MAXLOGMEMBERS 3

MAXDATAFILES 1022

MAXINSTANCES 50

MAXLOGHISTORY 12705

LOGFILE

GROUP 11 (

'O:\ORACLE\QK1\ORIGLOGA\LOG_G11M1.DBF',

'M:\ORACLE\QK1\MIRRLOGA\LOG_G11M2.DBF'

) SIZE 20M,

GROUP 12 (

'M:\ORACLE\QK1\ORIGLOGB\LOG_G12M1.DBF',

'O:\ORACLE\QK1\MIRRLOGB\LOG_G12M2.DBF'

) SIZE 20M,

GROUP 13 (

'O:\ORACLE\QK1\ORIGLOGA\LOG_G13M1.DBF',

'M:\ORACLE\QK1\MIRRLOGA\LOG_G13M2.DBF'

) SIZE 20M,

GROUP 14 (

'M:\ORACLE\QK1\ORIGLOGB\LOG_G14M1.DBF',

'O:\ORACLE\QK1\MIRRLOGB\LOG_G14M2.DBF'

) SIZE 20M

-- STANDBY LOGFILE

DATAFILE

'G:\ORACLE\QK1\SAPDATA1\SYSTEM_1\SYSTEM.DATA1',

'G:\ORACLE\QK1\SAPDATA1\SYSAUX_1\SYSAUX.DATA1',

'G:\ORACLE\QK1\SAPDATA1\UNDO_3\UNDO.DATA3',

'G:\ORACLE\QK1\SAPDATA2\STABI_1\STABI.DATA1',

'G:\ORACLE\QK1\SAPDATA3\STABD_1\STABD.DATA1',

'G:\ORACLE\QK1\SAPDATA1\BTABI_1\BTABI.DATA1',

'G:\ORACLE\QK1\SAPDATA6\BTABD_1\BTABD.DATA1',

'G:\ORACLE\QK1\SAPDATA2\POOLI_1\POOLI.DATA1',

'G:\ORACLE\QK1\SAPDATA6\POOLD_1\POOLD.DATA1',

'G:\ORACLE\QK1\SAPDATA6\CLUI_1\CLUI.DATA1',

'G:\ORACLE\QK1\SAPDATA6\CLUD_1\CLUD.DATA1',

'G:\ORACLE\QK1\SAPDATA6\DDICI_1\DDICI.DATA1',

'G:\ORACLE\QK1\SAPDATA3\DDICD_1\DDICD.DATA1',

'G:\ORACLE\QK1\SAPDATA6\DOCUI_1\DOCUI.DATA1',

'G:\ORACLE\QK1\SAPDATA1\DOCUD_1\DOCUD.DATA1',

'G:\ORACLE\QK1\SAPDATA6\EL46BI_1\EL46BI.DATA1',

'G:\ORACLE\QK1\SAPDATA1\EL46BD_1\EL46BD.DATA1',

'G:\ORACLE\QK1\SAPDATA6\LOADI_1\LOADI.DATA1',

'G:\ORACLE\QK1\SAPDATA6\LOADD_1\LOADD.DATA1',

'G:\ORACLE\QK1\SAPDATA1\PROTI_1\PROTI.DATA1',

'G:\ORACLE\QK1\SAPDATA1\PROTD_1\PROTD.DATA1',

'G:\ORACLE\QK1\SAPDATA4\ES46BI_1\ES46BI.DATA1',

'G:\ORACLE\QK1\SAPDATA5\ES46BD_1\ES46BD.DATA1',

'G:\ORACLE\QK1\SAPDATA5\ES46BD_2\ES46BD.DATA2',

'G:\ORACLE\QK1\SAPDATA6\SOURCEI_1\SOURCEI.DATA1',

'G:\ORACLE\QK1\SAPDATA6\SOURCED_1\SOURCED.DATA1',

'G:\ORACLE\QK1\SAPDATA1\USER1D_1\USER1D.DATA1',

'G:\ORACLE\QK1\SAPDATA1\USER1I_1\USER1I.DATA1',

'G:\ORACLE\QK1\SAPDATA5\ES46BD_3\ES46BD.DATA3',

'G:\ORACLE\QK1\SAPDATA4\ES46BI_2\ES46BI.DATA2',

'G:\ORACLE\QK1\SAPDATA6\POOLD_2\POOLD.DATA2',

'G:\ORACLE\QK1\SAPDATA2\POOLI_2\POOLI.DATA2',

'G:\ORACLE\QK1\SAPDATA3\STABD_2\STABD.DATA2',

'G:\ORACLE\QK1\SAPDATA2\STABI_2\STABI.DATA2',

'G:\ORACLE\QK1\SAPDATA6\BTABD_2\BTABD.DATA2',

'G:\ORACLE\QK1\SAPDATA1\BTABI_2\BTABI.DATA2',

'G:\ORACLE\QK1\SAPDATA6\BTABD_3\BTABD.DATA3',

'G:\ORACLE\QK1\SAPDATA6\CLUD_2\CLUD.DATA2',

'G:\ORACLE\QK1\SAPDATA6\CLUD_3\CLUD.DATA3',

'G:\ORACLE\QK1\SAPDATA6\CLUI_2\CLUI.DATA2',

'G:\ORACLE\QK1\SAPDATA6\CLUD_4\CLUD.DATA4',

'G:\ORACLE\QK1\SAPDATA6\CLUI_3\CLUI.DATA3',

'G:\ORACLE\QK1\SAPDATA6\BTABD_4\BTABD.DATA4',

'G:\ORACLE\QK1\SAPDATA3\DDICD_2\DDICD.DATA2',

'G:\ORACLE\QK1\SAPDATA1\PROTD_2\PROTD.DATA2',

'G:\ORACLE\QK1\SAPDATA6\CLUD_5\CLUD.DATA5',

'G:\ORACLE\QK1\SAPDATA3\STABD_3\STABD.DATA3',

'G:\ORACLE\QK1\SAPDATA6\BTABD_5\BTABD.DATA5',

'G:\ORACLE\QK1\SAPDATA6\DDICI_2\DDICI.DATA2',

'G:\ORACLE\QK1\SAPDATA5\ES46BD_4\ES46BD.DATA4',

'G:\ORACLE\QK1\SAPDATA2\STABI_3\STABI.DATA3',

'G:\ORACLE\QK1\SAPDATA1\BTABI_3\BTABI.DATA3',

'G:\ORACLE\QK1\SAPDATA1\EL46BD_2\EL46BD.DATA2',

'G:\ORACLE\QK1\SAPDATA6\BTABD_6\BTABD.DATA6',

'G:\ORACLE\QK1\SAPDATA1\PROTI_2\PROTI.DATA2',

'G:\ORACLE\QK1\SAPDATA6\BTABD_7\BTABD.DATA7',

'G:\ORACLE\QK1\SAPDATA1\BTABI_4\BTABI.DATA4',

'G:\ORACLE\QK1\SAPDATA6\BTABD_8\BTABD.DATA8',

'G:\ORACLE\QK1\SAPDATA6\BTABD_9\BTABD.DATA9',

'G:\ORACLE\QK1\SAPDATA1\BTABI_5\BTABI.DATA5',

'G:\ORACLE\QK1\SAPDATA3\STABD_4\STABD.DATA4',

'G:\ORACLE\QK1\SAPDATA1\EL46BD_3\EL46BD.DATA3',

'G:\ORACLE\QK1\SAPDATA6\BTABD_10\BTABD.DATA10',

'G:\ORACLE\QK1\SAPDATA6\BTABD_11\BTABD.DATA11',

'G:\ORACLE\QK1\SAPDATA1\BTABI_6\BTABI.DATA6',

'G:\ORACLE\QK1\SAPDATA6\SOURCED_2\SOURCED.DATA2',

'G:\ORACLE\QK1\SAPDATA6\BTABD_12\BTABD.DATA12',

'G:\ORACLE\QK1\SAPDATA1\BTABI_7\BTABI.DATA7',

'G:\ORACLE\QK1\SAPDATA6\BTABD_13\BTABD.DATA13',

'G:\ORACLE\QK1\SAPDATA1\PROTD_3\PROTD.DATA3',

'G:\ORACLE\QK1\SAPDATA6\BTABD_14\BTABD.DATA14',

'G:\ORACLE\QK1\SAPDATA1\BTABI_8\BTABI.DATA8',

'G:\ORACLE\QK1\SAPDATA6\BTABD_15\BTABD.DATA15',

'G:\ORACLE\QK1\SAPDATA6\CLUI_4\CLUI.DATA4',

'G:\ORACLE\QK1\SAPDATA6\BTABD_16\BTABD.DATA16',

'G:\ORACLE\QK1\SAPDATA1\BTABI_9\BTABI.DATA9',

'G:\ORACLE\QK1\SAPDATA1\EL46CD_3\EL46CD.DATA3',

'G:\ORACLE\QK1\SAPDATA1\SYSTEM_2\SYSTEM.DATA2',

'G:\ORACLE\QK1\SAPDATA1\ES46CD_1\ES46CD.DATA1',

'G:\ORACLE\QK1\SAPDATA1\ES46CD_2\ES46CD.DATA2',

'G:\ORACLE\QK1\SAPDATA1\ES46CD_3\ES46CD.DATA3',

'G:\ORACLE\QK1\SAPDATA1\ES46CI_1\ES46CI.DATA1',

'G:\ORACLE\QK1\SAPDATA1\ES46CI_2\ES46CI.DATA2',

'G:\ORACLE\QK1\SAPDATA1\EL46CD_1\EL46CD.DATA1',

'G:\ORACLE\QK1\SAPDATA1\EL46CI_1\EL46CI.DATA1',

'G:\ORACLE\QK1\SAPDATA1\EL46CD_2\EL46CD.DATA2',

'G:\ORACLE\QK1\SAPDATA6\BTABD_17\BTABD.DATA17',

'G:\ORACLE\QK1\SAPDATA2\STABI_4\STABI.DATA4',

'G:\ORACLE\QK1\SAPDATA6\BTABD_18\BTABD.DATA18',

'G:\ORACLE\QK1\SAPDATA1\BTABI_10\BTABI.DATA10',

'T:\ORACLE\QK1\SAPDATA7\STABD_22\STABD.DATA22',

'T:\ORACLE\QK1\SAPDATA7\BTABD_154\BTABD.DATA154',

'G:\ORACLE\QK1\SAPDATA6\BTABD_19\BTABD.DATA19',

'G:\ORACLE\QK1\SAPDATA3\STABD_5\STABD.DATA5',

'G:\ORACLE\QK1\SAPDATA1\BTABI_11\BTABI.DATA11',

'G:\ORACLE\QK1\SAPDATA6\BTABD_20\BTABD.DATA20',

'G:\ORACLE\QK1\SAPDATA6\BTABD_21\BTABD.DATA21',

'G:\ORACLE\QK1\SAPDATA1\BTABI_12\BTABI.DATA12',

'G:\ORACLE\QK1\SAPDATA6\BTABD_22\BTABD.DATA22',

'G:\ORACLE\QK1\SAPDATA1\BTABI_13\BTABI.DATA13',

'T:\ORACLE\QK1\SAPDATA7\BTABD_155\BTABD.DATA155',

'G:\ORACLE\QK1\SAPDATA1\BTABI_14\BTABI.DATA14',

'G:\ORACLE\QK1\SAPDATA6\BTABD_23\BTABD.DATA23',

'G:\ORACLE\QK1\SAPDATA6\BTABD_24\BTABD.DATA24',

'G:\ORACLE\QK1\SAPDATA6\BTABD_25\BTABD.DATA25',

'G:\ORACLE\QK1\SAPDATA3\STABD_6\STABD.DATA6',

'G:\ORACLE\QK1\SAPDATA6\BTABD_26\BTABD.DATA26',

'G:\ORACLE\QK1\SAPDATA6\BTABD_27\BTABD.DATA27',

'G:\ORACLE\QK1\SAPDATA6\BTABD_28\BTABD.DATA28',

'G:\ORACLE\QK1\SAPDATA2\STABI_5\STABI.DATA5',

'G:\ORACLE\QK1\SAPDATA1\DOCUD_2\DOCUD.DATA2',

'G:\ORACLE\QK1\SAPDATA6\LOADD_2\LOADD.DATA2',

'G:\ORACLE\QK1\SAPDATA6\SOURCED_3\SOURCED.DATA3',

'G:\ORACLE\QK1\SAPDATA1\BTABI_15\BTABI.DATA15',

'G:\ORACLE\QK1\SAPDATA3\STABD_7\STABD.DATA7',

'G:\ORACLE\QK1\SAPDATA6\BTABD_29\BTABD.DATA29',

'G:\ORACLE\QK1\SAPDATA6\BTABD_30\BTABD.DATA30',

'G:\ORACLE\QK1\SAPDATA1\BTABI_16\BTABI.DATA16',

'G:\ORACLE\QK1\SAPDATA6\BTABD_31\BTABD.DATA31',

'G:\ORACLE\QK1\SAPDATA1\SYSTEM_3\SYSTEM.DATA3',

'G:\ORACLE\QK1\SAPDATA1\USER1D_2\USER1D.DATA2',

'G:\ORACLE\QK1\SAPDATA1\BTABI_17\BTABI.DATA17',

'G:\ORACLE\QK1\SAPDATA6\BTABD_32\BTABD.DATA32',

'G:\ORACLE\QK1\SAPDATA1\SYSTEM_4\SYSTEM.DATA4',

'G:\ORACLE\QK1\SAPDATA1\UNDO_4\UNDO.DATA4',

'G:\ORACLE\QK1\SAPDATA1\BTABI_18\BTABI.DATA18',

'G:\ORACLE\QK1\SAPDATA6\BTABD_33\BTABD.DATA33',

'G:\ORACLE\QK1\SAPDATA6\BTABD_34\BTABD.DATA34',

'G:\ORACLE\QK1\SAPDATA6\BTABD_35\BTABD.DATA35',

'G:\ORACLE\QK1\SAPDATA1\BTABI_19\BTABI.DATA19',

'G:\ORACLE\QK1\SAPDATA6\BTABD_36\BTABD.DATA36',

'G:\ORACLE\QK1\SAPDATA3\STABD_8\STABD.DATA8',

'G:\ORACLE\QK1\SAPDATA1\BTABI_20\BTABI.DATA20',

'G:\ORACLE\QK1\SAPDATA1\BTABI_21\BTABI.DATA21',

'G:\ORACLE\QK1\SAPDATA6\CLUI_5\CLUI.DATA5',

'G:\ORACLE\QK1\SAPDATA2\STABI_6\STABI.DATA6',

'G:\ORACLE\QK1\SAPDATA6\BTABD_37\BTABD.DATA37',

'G:\ORACLE\QK1\SAPDATA6\CLUD_6\CLUD.DATA6',

'G:\ORACLE\QK1\SAPDATA6\POOLD_3\POOLD.DATA3',

'G:\ORACLE\QK1\SAPDATA6\BTABD_38\BTABD.DATA38',

'G:\ORACLE\QK1\SAPDATA6\BTABD_39\BTABD.DATA39',

'G:\ORACLE\QK1\SAPDATA1\PROTI_3\PROTI.DATA3',

'G:\ORACLE\QK1\SAPDATA1\BTABI_22\BTABI.DATA22',

'G:\ORACLE\QK1\SAPDATA6\BTABD_40\BTABD.DATA40',

'G:\ORACLE\QK1\SAPDATA1\BTABI_23\BTABI.DATA23',

'G:\ORACLE\QK1\SAPDATA6\BTABD_41\BTABD.DATA41',

'G:\ORACLE\QK1\SAPDATA1\TABI_1\TABI.DATA1',

'G:\ORACLE\QK1\SAPDATA6\BTABD_42\BTABD.DATA42',

'G:\ORACLE\QK1\SAPDATA6\BTABD_43\BTABD.DATA43',

'G:\ORACLE\QK1\SAPDATA3\STABD_9\STABD.DATA9',

'G:\ORACLE\QK1\SAPDATA1\BTABI_24\BTABI.DATA24',

'G:\ORACLE\QK1\SAPDATA6\BTABD_44\BTABD.DATA44',

'G:\ORACLE\QK1\SAPDATA6\BTABD_45\BTABD.DATA45',

'G:\ORACLE\QK1\SAPDATA6\BTABD_46\BTABD.DATA46',

'G:\ORACLE\QK1\SAPDATA1\BTABI_25\BTABI.DATA25',

'G:\ORACLE\QK1\SAPDATA6\BTABD_47\BTABD.DATA47',

'G:\ORACLE\QK1\SAPDATA1\BTABI_26\BTABI.DATA26',

'G:\ORACLE\QK1\SAPDATA6\BTABD_48\BTABD.DATA48',

'G:\ORACLE\QK1\SAPDATA6\BTABD_49\BTABD.DATA49',

'G:\ORACLE\QK1\SAPDATA1\BTABI_27\BTABI.DATA27',

'G:\ORACLE\QK1\SAPDATA3\STABD_10\STABD.DATA10',

'G:\ORACLE\QK1\SAPDATA2\STABI_7\STABI.DATA7',

'G:\ORACLE\QK1\SAPDATA6\BTABD_50\BTABD.DATA50',

'G:\ORACLE\QK1\SAPDATA1\BTABI_28\BTABI.DATA28',

'G:\ORACLE\QK1\SAPDATA6\BTABD_51\BTABD.DATA51',

'G:\ORACLE\QK1\SAPDATA1\BTABI_29\BTABI.DATA29',

'G:\ORACLE\QK1\SAPDATA6\BTABD_52\BTABD.DATA52',

'G:\ORACLE\QK1\SAPDATA1\BTABI_30\BTABI.DATA30',

'G:\ORACLE\QK1\SAPDATA6\BTABD_53\BTABD.DATA53',

'G:\ORACLE\QK1\SAPDATA6\BTABD_54\BTABD.DATA54',

'G:\ORACLE\QK1\SAPDATA1\UNDO_5\UNDO.DATA5',

'G:\ORACLE\QK1\SAPDATA6\BTABD_55\BTABD.DATA55',

'G:\ORACLE\QK1\SAPDATA1\BTABI_31\BTABI.DATA31',

'G:\ORACLE\QK1\SAPDATA6\BTABD_56\BTABD.DATA56',

'G:\ORACLE\QK1\SAPDATA6\BTABD_57\BTABD.DATA57',

'G:\ORACLE\QK1\SAPDATA1\BTABI_32\BTABI.DATA32',

'G:\ORACLE\QK1\SAPDATA3\STABD_11\STABD.DATA11',

'G:\ORACLE\QK1\SAPDATA6\BTABD_58\BTABD.DATA58',

'G:\ORACLE\QK1\SAPDATA1\BTABI_33\BTABI.DATA33',

'G:\ORACLE\QK1\SAPDATA6\BTABD_59\BTABD.DATA59',

'G:\ORACLE\QK1\SAPDATA1\BTABI_34\BTABI.DATA34',

'G:\ORACLE\QK1\SAPDATA1\USER1I_2\USER1I.DATA2',

'T:\ORACLE\QK1\SAPDATA7\UNDO_7\UNDO7.DATA7',

'G:\ORACLE\QK1\SAPDATA6\BTABD_60\BTABD.DATA60',

'G:\ORACLE\QK1\SAPDATA1\BTABI_35\BTABI.DATA35',

'G:\ORACLE\QK1\SAPDATA6\CLUD_7\CLUD.DATA7',

'G:\ORACLE\QK1\SAPDATA3\STABD_12\STABD.DATA12',

'G:\ORACLE\QK1\SAPDATA6\BTABD_61\BTABD.DATA61',

'G:\ORACLE\QK1\SAPDATA1\BTABI_36\BTABI.DATA36',

'G:\ORACLE\QK1\SAPDATA1\BTABI_37\BTABI.DATA37',

'G:\ORACLE\QK1\SAPDATA6\BTABD_62\BTABD.DATA62',

'G:\ORACLE\QK1\SAPDATA6\BTABD_63\BTABD.DATA63',

'G:\ORACLE\QK1\SAPDATA1\BTABI_38\BTABI.DATA38',

'G:\ORACLE\QK1\SAPDATA6\BTABD_64\BTABD.DATA64',

'G:\ORACLE\QK1\SAPDATA1\BTABI_39\BTABI.DATA39',

'G:\ORACLE\QK1\SAPDATA3\STABD_13\STABD.DATA13',

'G:\ORACLE\QK1\SAPDATA2\STABI_8\STABI.DATA8',

'G:\ORACLE\QK1\SAPDATA1\BTABI_40\BTABI.DATA40',

'G:\ORACLE\QK1\SAPDATA6\BTABD_65\BTABD.DATA65',

'G:\ORACLE\QK1\SAPDATA1\BTABI_41\BTABI.DATA41',

'G:\ORACLE\QK1\SAPDATA1\BTABI_42\BTABI.DATA42',

'G:\ORACLE\QK1\SAPDATA6\BTABD_66\BTABD.DATA66',

'G:\ORACLE\QK1\SAPDATA6\BTABD_67\BTABD.DATA67',

'G:\ORACLE\QK1\SAPDATA6\BTABD_68\BTABD.DATA68',

'G:\ORACLE\QK1\SAPDATA1\BTABI_43\BTABI.DATA43',

'G:\ORACLE\QK1\SAPDATA1\BTABI_44\BTABI.DATA44',

'G:\ORACLE\QK1\SAPDATA1\BTABI_45\BTABI.DATA45',

'G:\ORACLE\QK1\SAPDATA6\BTABD_69\BTABD.DATA69',

'G:\ORACLE\QK1\SAPDATA1\BTABI_46\BTABI.DATA46',

'G:\ORACLE\QK1\SAPDATA2\POOLI_3\POOLI.DATA3',

'G:\ORACLE\QK1\SAPDATA6\BTABD_70\BTABD.DATA70',

'G:\ORACLE\QK1\SAPDATA6\BTABD_71\BTABD.DATA71',

'G:\ORACLE\QK1\SAPDATA6\BTABD_72\BTABD.DATA72',

'G:\ORACLE\QK1\SAPDATA1\BTABI_47\BTABI.DATA47',

'G:\ORACLE\QK1\SAPDATA6\BTABD_73\BTABD.DATA73',

'G:\ORACLE\QK1\SAPDATA6\BTABD_74\BTABD.DATA74',

'G:\ORACLE\QK1\SAPDATA1\BTABI_48\BTABI.DATA48',

'G:\ORACLE\QK1\SAPDATA6\BTABD_75\BTABD.DATA75',

'G:\ORACLE\QK1\SAPDATA1\BTABI_49\BTABI.DATA49',

'G:\ORACLE\QK1\SAPDATA6\BTABD_76\BTABD.DATA76',

'G:\ORACLE\QK1\SAPDATA6\BTABD_77\BTABD.DATA77',

'G:\ORACLE\QK1\SAPDATA1\BTABI_50\BTABI.DATA50',

'G:\ORACLE\QK1\SAPDATA6\BTABD_78\BTABD.DATA78',

'G:\ORACLE\QK1\SAPDATA1\BTABI_51\BTABI.DATA51',

'G:\ORACLE\QK1\SAPDATA6\CLUD_8\CLUD.DATA8',

'G:\ORACLE\QK1\SAPDATA6\BTABD_79\BTABD.DATA79',

'G:\ORACLE\QK1\SAPDATA6\BTABD_80\BTABD.DATA80',

'G:\ORACLE\QK1\SAPDATA1\BTABI_52\BTABI.DATA52',

'T:\ORACLE\QK1\SAPDATA7\BTABD_81\BTABD.DATA81',

'T:\ORACLE\QK1\SAPDATA8\BTABI_53\BTABI.DATA53',

'T:\ORACLE\QK1\SAPDATA7\CLUD_9\CLUD.DATA9',

'T:\ORACLE\QK1\SAPDATA7\BTABD_82\BTABD.DATA82',

'T:\ORACLE\QK1\SAPDATA8\BTABI_54\BTABI.DATA54',

'T:\ORACLE\QK1\SAPDATA7\CLUD_10\CLUD.DATA10',

'T:\ORACLE\QK1\SAPDATA7\BTABD_83\BTABD.DATA83',

'T:\ORACLE\QK1\SAPDATA7\CLUD_11\CLUD.DATA11',

'T:\ORACLE\QK1\SAPDATA7\BTABD_84\BTABD.DATA84',

'T:\ORACLE\QK1\SAPDATA7\CLUD_12\CLUD.DATA12',

'T:\ORACLE\QK1\SAPDATA7\BTABD_85\BTABD.DATA85',

'T:\ORACLE\QK1\SAPDATA8\BTABI_55\BTABI.DATA55',

'G:\ORACLE\QK1\SAPDATA6\CLUI_6\CLUI.DATA6',

'T:\ORACLE\QK1\SAPDATA7\CLUD_13\CLUD.DATA13',

'T:\ORACLE\QK1\SAPDATA7\BTABD_86\BTABD.DATA86',

'T:\ORACLE\QK1\SAPDATA7\BTABD_87\BTABD.DATA87',

'T:\ORACLE\QK1\SAPDATA7\BTABD_88\BTABD.DATA88',

'T:\ORACLE\QK1\SAPDATA7\BTABD_89\BTABD.DATA89',

'T:\ORACLE\QK1\SAPDATA8\BTABI_56\BTABI.DATA56',

'T:\ORACLE\QK1\SAPDATA7\BTABD_90\BTABD.DATA90',

'T:\ORACLE\QK1\SAPDATA7\BTABD_91\BTABD.DATA91',

'T:\ORACLE\QK1\SAPDATA8\BTABI_57\BTABI.DATA57',

'G:\ORACLE\QK1\SAPDATA6\BTABD_92\BTABD.DATA92',

'T:\ORACLE\QK1\SAPDATA7\BTABD_93\BTABD.DATA93',

'T:\ORACLE\QK1\SAPDATA8\BTABI_58\BTABI.DATA58',

'T:\ORACLE\QK1\SAPDATA7\BTABD_94\BTABD.DATA94',

'T:\ORACLE\QK1\SAPDATA7\BTABD_95\BTABD.DATA95',

'T:\ORACLE\QK1\SAPDATA8\BTABI_59\BTABI.DATA59',

'T:\ORACLE\QK1\SAPDATA8\BTABI_60\BTABI.DATA60',

'T:\ORACLE\QK1\SAPDATA7\BTABD_96\BTABD.DATA96',

'T:\ORACLE\QK1\SAPDATA7\BTABD_97\BTABD.DATA97',

'T:\ORACLE\QK1\SAPDATA7\BTABD_98\BTABD.DATA98',

'T:\ORACLE\QK1\SAPDATA8\BTABI_61\BTABI.DATA61',

'T:\ORACLE\QK1\SAPDATA8\BTABI_62\BTABI.DATA62',

'T:\ORACLE\QK1\SAPDATA7\STABD_14\STABD.DATA14',

'T:\ORACLE\QK1\SAPDATA8\STABI_9\STABI.DATA9',

'T:\ORACLE\QK1\SAPDATA7\BTABD_99\BTABD.DATA99',

'T:\ORACLE\QK1\SAPDATA8\TABD_1\TABD.DATA1',

'T:\ORACLE\QK1\SAPDATA8\BTABI_63\BTABI.DATA63',

'T:\ORACLE\QK1\SAPDATA7\BTABD_100\BTABD.DATA100',

'T:\ORACLE\QK1\SAPDATA7\BTABD_101\BTABD.DATA101',

'T:\ORACLE\QK1\SAPDATA7\BTABD_102\BTABD.DATA102',

'T:\ORACLE\QK1\SAPDATA7\BTABD_103\BTABD.DATA103',

'T:\ORACLE\QK1\SAPDATA8\BTABI_64\BTABI.DATA64',

'T:\ORACLE\QK1\SAPDATA7\BTABD_104\BTABD.DATA104',

'T:\ORACLE\QK1\SAPDATA8\BTABI_65\BTABI.DATA65',

'T:\ORACLE\QK1\SAPDATA7\BTABD_105\BTABD.DATA105',

'T:\ORACLE\QK1\SAPDATA7\BTABD_106\BTABD.DATA106',

'T:\ORACLE\QK1\SAPDATA8\BTABI_66\BTABI.DATA66',

'T:\ORACLE\QK1\SAPDATA7\BTABD_107\BTABD.DATA107',

'T:\ORACLE\QK1\SAPDATA7\BTABD_108\BTABD.DATA108',

'T:\ORACLE\QK1\SAPDATA8\BTABI_67\BTABI.DATA67',

'T:\ORACLE\QK1\SAPDATA7\BTABD_109\BTABD.DATA109',

'T:\ORACLE\QK1\SAPDATA8\BTABI_68\BTABI.DATA68',

'T:\ORACLE\QK1\SAPDATA8\BTABI_69\BTABI.DATA69',

'T:\ORACLE\QK1\SAPDATA7\BTABD_110\BTABD.DATA110',

'T:\ORACLE\QK1\SAPDATA7\BTABD_111\BTABD.DATA111',

'T:\ORACLE\QK1\SAPDATA7\BTABD_112\BTABD.DATA112',

'T:\ORACLE\QK1\SAPDATA7\BTABD_113\BTABD.DATA113',

'T:\ORACLE\QK1\SAPDATA7\BTABD_114\BTABD.DATA114',

'T:\ORACLE\QK1\SAPDATA8\BTABI_70\BTABI.DATA70',

'T:\ORACLE\QK1\SAPDATA7\STABD_15\STABD.DATA15',

'T:\ORACLE\QK1\SAPDATA7\BTABD_115\BTABD.DATA115',

'T:\ORACLE\QK1\SAPDATA7\BTABD_116\BTABD.DATA116',

'T:\ORACLE\QK1\SAPDATA8\BTABI_71\BTABI.DATA71',

'T:\ORACLE\QK1\SAPDATA7\CLUD_14\CLUD.DATA14',

'T:\ORACLE\QK1\SAPDATA7\BTABD_117\BTABD.DATA117',

'T:\ORACLE\QK1\SAPDATA7\BTABD_118\BTABD.DATA118',

'T:\ORACLE\QK1\SAPDATA8\BTABI_72\BTABI.DATA72',

'T:\ORACLE\QK1\SAPDATA7\BTABD_119\BTABD.DATA119',

'T:\ORACLE\QK1\SAPDATA8\BTABI_73\BTABI.DATA73',

'T:\ORACLE\QK1\SAPDATA8\STABI_10\STABI.DATA10',

'T:\ORACLE\QK1\SAPDATA8\BTABI_74\BTABI.DATA74',

'T:\ORACLE\QK1\SAPDATA8\BTABI_75\BTABI.DATA75',

'T:\ORACLE\QK1\SAPDATA7\BTABD_120\BTABD.DATA120',

'T:\ORACLE\QK1\SAPDATA7\STABD_16\STABD.DATA16',

'T:\ORACLE\QK1\SAPDATA7\BTABD_121\BTABD.DATA121',

'T:\ORACLE\QK1\SAPDATA7\BTABD_122\BTABD.DATA122',

'T:\ORACLE\QK1\SAPDATA8\BTABI_76\BTABI.DATA76',

'T:\ORACLE\QK1\SAPDATA8\BTABI_77\BTABI.DATA77',

'T:\ORACLE\QK1\SAPDATA7\STABD_17\STABD.DATA17',

'T:\ORACLE\QK1\SAPDATA8\STABI_11\STABI.DATA11',

'T:\ORACLE\QK1\SAPDATA7\BTABD_123\BTABD.DATA123',

'T:\ORACLE\QK1\SAPDATA8\BTABI_78\BTABI.DATA78',

'T:\ORACLE\QK1\SAPDATA7\BTABD_124\BTABD.DATA124',

'T:\ORACLE\QK1\SAPDATA7\BTABD_125\BTABD.DATA125',

'T:\ORACLE\QK1\SAPDATA8\BTABI_79\BTABI.DATA79',

'T:\ORACLE\QK1\SAPDATA8\BTABI_80\BTABI.DATA80',

'T:\ORACLE\QK1\SAPDATA7\BTABD_126\BTABD.DATA126',

'T:\ORACLE\QK1\SAPDATA7\BTABD_127\BTABD.DATA127',

'T:\ORACLE\QK1\SAPDATA8\BTABI_81\BTABI.DATA81',

'T:\ORACLE\QK1\SAPDATA7\BTABD_128\BTABD.DATA128',

'T:\ORACLE\QK1\SAPDATA8\BTABI_82\BTABI.DATA82',

'T:\ORACLE\QK1\SAPDATA7\BTABD_129\BTABD.DATA129',

'T:\ORACLE\QK1\SAPDATA8\BTABI_83\BTABI.DATA83',

'T:\ORACLE\QK1\SAPDATA7\BTABD_130\BTABD.DATA130',

'T:\ORACLE\QK1\SAPDATA8\BTABI_84\BTABI.DATA84',

'T:\ORACLE\QK1\SAPDATA7\BTABD_131\BTABD.DATA131',

'T:\ORACLE\QK1\SAPDATA8\BTABI_85\BTABI.DATA85',

'T:\ORACLE\QK1\SAPDATA7\BTABD_132\BTABD.DATA132',

'T:\ORACLE\QK1\SAPDATA7\BTABD_133\BTABD.DATA133',

'T:\ORACLE\QK1\SAPDATA7\BTABD_134\BTABD.DATA134',

'T:\ORACLE\QK1\SAPDATA7\BTABD_135\BTABD.DATA135',

'T:\ORACLE\QK1\SAPDATA8\BTABI_86\BTABI.DATA86',

'T:\ORACLE\QK1\SAPDATA7\BTABD_136\BTABD.DATA136',

'T:\ORACLE\QK1\SAPDATA8\BTABI_87\BTABI.DATA87',

'T:\ORACLE\QK1\SAPDATA7\BTABD_137\BTABD.DATA137',

'T:\ORACLE\QK1\SAPDATA7\BTABD_138\BTABD.DATA138',

'T:\ORACLE\QK1\SAPDATA8\BTABI_88\BTABI.DATA88',

'T:\ORACLE\QK1\SAPDATA8\BTABI_89\BTABI.DATA89',

'T:\ORACLE\QK1\SAPDATA7\BTABD_139\BTABD.DATA139',

'T:\ORACLE\QK1\SAPDATA8\BTABI_90\BTABI.DATA90',

'T:\ORACLE\QK1\SAPDATA7\BTABD_140\BTABD.DATA140',

'T:\ORACLE\QK1\SAPDATA8\BTABI_91\BTABI.DATA91',

'T:\ORACLE\QK1\SAPDATA7\BTABD_141\BTABD.DATA141',

'T:\ORACLE\QK1\SAPDATA7\BTABD_142\BTABD.DATA142',

'T:\ORACLE\QK1\SAPDATA7\STABD_18\STABD.DATA18',

'T:\ORACLE\QK1\SAPDATA7\STABD_19\STABD.DATA19',

'T:\ORACLE\QK1\SAPDATA8\STABI_12\STABI.DATA12',

'T:\ORACLE\QK1\SAPDATA7\BTABD_143\BTABD.DATA143',

'T:\ORACLE\QK1\SAPDATA7\STABD_20\STABD.DATA20',

'T:\ORACLE\QK1\SAPDATA7\STABD_21\STABD.DATA21',

'T:\ORACLE\QK1\SAPDATA7\BTABD_144\BTABD.DATA144',

'T:\ORACLE\QK1\SAPDATA8\BTABI_92\BTABI.DATA92',

'T:\ORACLE\QK1\SAPDATA7\BTABD_145\BTABD.DATA145',

'T:\ORACLE\QK1\SAPDATA8\BTABI_93\BTABI.DATA93',

'T:\ORACLE\QK1\SAPDATA7\BTABD_146\BTABD.DATA146',

'T:\ORACLE\QK1\SAPDATA7\BTABD_147\BTABD.DATA147',

'T:\ORACLE\QK1\SAPDATA7\BTABD_148\BTABD.DATA148',

'T:\ORACLE\QK1\SAPDATA7\BTABD_149\BTABD.DATA149',

'T:\ORACLE\QK1\SAPDATA8\BTABI_94\BTABI.DATA94',

'T:\ORACLE\QK1\SAPDATA8\BTABI_95\BTABI.DATA95',

'T:\ORACLE\QK1\SAPDATA8\BTABI_96\BTABI.DATA96',

'T:\ORACLE\QK1\SAPDATA7\BTABD_150\BTABD.DATA150',

'T:\ORACLE\QK1\SAPDATA8\BTABI_97\BTABI.DATA97',

'T:\ORACLE\QK1\SAPDATA8\BTABI_98\BTABI.DATA98',

'T:\ORACLE\QK1\SAPDATA7\BTABD_151\BTABD.DATA151',

'T:\ORACLE\QK1\SAPDATA7\BTABD_152\BTABD.DATA152',

'T:\ORACLE\QK1\SAPDATA8\BTABI_99\BTABI.DATA99',

'T:\ORACLE\QK1\SAPDATA8\BTABI_100\BTABI.DATA100',

'T:\ORACLE\QK1\SAPDATA7\BTABD_153\BTABD.DATA153',

'G:\ORACLE\QK1\SAPDATA1\SYSTEM_5\SYSTEM.DATA5',

'G:\ORACLE\QK1\SAPDATA1\UNDO_1\UNDO.DATA1',

'G:\ORACLE\QK1\SAPDATA1\UNDO_2\UNDO.DATA2',

'T:\ORACLE\QK1\SAPDATA7\BTABD_156\BTABD.DATA156',

'T:\ORACLE\QK1\SAPDATA7\BTABD_157\BTABD.DATA157',

'T:\ORACLE\QK1\SAPDATA7\BTABD_158\BTABD.DATA158',

'T:\ORACLE\QK1\SAPDATA7\BTABD_159\BTABD.DATA159',

'T:\ORACLE\QK1\SAPDATA7\BTABD_160\BTABD.DATA160',

'T:\ORACLE\QK1\SAPDATA8\BTABI_101\BTABI.DATA101',

'T:\ORACLE\QK1\SAPDATA7\BTABD_161\BTABD.DATA161',

'T:\ORACLE\QK1\SAPDATA8\BTABI_102\BTABI.DATA102',

'T:\ORACLE\QK1\SAPDATA7\BTABD_162\BTABD.DATA162',

'T:\ORACLE\QK1\SAPDATA8\BTABI_103\BTABI.DATA103',

'T:\ORACLE\QK1\SAPDATA7\BTABD_163\BTABD.DATA163',

'T:\ORACLE\QK1\SAPDATA7\BTABD_164\BTABD.DATA164',

'T:\ORACLE\QK1\SAPDATA8\BTABI_104\BTABI.DATA104',

'T:\ORACLE\QK1\SAPDATA7\BTABD_165\BTABD.DATA165',

'T:\ORACLE\QK1\SAPDATA8\BTABI_105\BTABI.DATA105',

'T:\ORACLE\QK1\SAPDATA8\STABI_13\STABI.DATA13',

'T:\ORACLE\QK1\SAPDATA7\BTABD_166\BTABD.DATA166',

'T:\ORACLE\QK1\SAPDATA7\BTABD_167\BTABD.DATA167',

'T:\ORACLE\QK1\SAPDATA7\BTABD_168\BTABD.DATA168',

'T:\ORACLE\QK1\SAPDATA8\BTABI_106\BTABI.DATA106',

'T:\ORACLE\QK1\SAPDATA7\BTABD_169\BTABD.DATA169',

'T:\ORACLE\QK1\SAPDATA8\BTABI_107\BTABI.DATA107',

'T:\ORACLE\QK1\SAPDATA7\BTABD_170\BTABD.DATA170',

'T:\ORACLE\QK1\SAPDATA8\BTABI_108\BTABI.DATA108',

'T:\ORACLE\QK1\SAPDATA7\BTABD_171\BTABD.DATA171',

'T:\ORACLE\QK1\SAPDATA8\BTABI_109\BTABI.DATA109',

'T:\ORACLE\QK1\SAPDATA7\CLUD_15\CLUD.DATA15',

'T:\ORACLE\QK1\SAPDATA8\BTABI_110\BTABI.DATA110',

'T:\ORACLE\QK1\SAPDATA8\BTABI_111\BTABI.DATA111',

'T:\ORACLE\QK1\SAPDATA8\BTABI_112\BTABI.DATA112',

'T:\ORACLE\QK1\SAPDATA8\BTABI_113\BTABI.DATA113',

'T:\ORACLE\QK1\SAPDATA7\BTABD_172\BTABD.DATA172',

'T:\ORACLE\QK1\SAPDATA7\BTABD_173\BTABD.DATA173',

'T:\ORACLE\QK1\SAPDATA7\BTABD_174\BTABD.DATA174',

'T:\ORACLE\QK1\SAPDATA7\STABD_23\STABD.DATA23',

'T:\ORACLE\QK1\SAPDATA7\BTABD_175\BTABD.DATA175',

'T:\ORACLE\QK1\SAPDATA7\BTABD_176\BTABD.DATA176',

'T:\ORACLE\QK1\SAPDATA8\BTABI_114\BTABI.DATA114',

'T:\ORACLE\QK1\SAPDATA7\BTABD_177\BTABD.DATA177',

'T:\ORACLE\QK1\SAPDATA8\BTABI_115\BTABI.DATA115',

'T:\ORACLE\QK1\SAPDATA7\BTABD_178\BTABD.DATA178',

'T:\ORACLE\QK1\SAPDATA8\BTABI_116\BTABI.DATA116',

'T:\ORACLE\QK1\SAPDATA7\BTABD_179\BTABD.DATA179',

'T:\ORACLE\QK1\SAPDATA8\BTABI_117\BTABI.DATA117',

'T:\ORACLE\QK1\SAPDATA7\CLUD_16\CLUD.DATA16',

'T:\ORACLE\QK1\SAPDATA7\STABD_24\STABD.DATA24',

'T:\ORACLE\QK1\SAPDATA8\STABI_14\STABI.DATA14',

'G:\ORACLE\QK1\SAPDATA2\POOLI_4\POOLI.DATA4',

'G:\ORACLE\QK1\SAPDATA6\POOLD_4\POOLD.DATA4',

'T:\ORACLE\QK1\SAPDATA7\CLUD_17\CLUD.DATA17',

'T:\ORACLE\QK1\SAPDATA7\BTABD_180\BTABD.DATA180',

'T:\ORACLE\QK1\SAPDATA7\BTABD_181\BTABD.DATA181',

'T:\ORACLE\QK1\SAPDATA8\BTABI_118\BTABI.DATA118',

'T:\ORACLE\QK1\SAPDATA7\BTABD_182\BTABD.DATA182',

'T:\ORACLE\QK1\SAPDATA8\BTABI_119\BTABI.DATA119',

'T:\ORACLE\QK1\SAPDATA7\BTABD_183\BTABD.DATA183',

'T:\ORACLE\QK1\SAPDATA8\BTABI_120\BTABI.DATA120',

'T:\ORACLE\QK1\SAPDATA7\BTABD_184\BTABD.DATA184',

'T:\ORACLE\QK1\SAPDATA7\BTABD_185\BTABD.DATA185',

'T:\ORACLE\QK1\SAPDATA7\BTABD_186\BTABD.DATA186',

'T:\ORACLE\QK1\SAPDATA8\BTABI_121\BTABI.DATA121',

'T:\ORACLE\QK1\SAPDATA7\BTABD_187\BTABD.DATA187',

'T:\ORACLE\QK1\SAPDATA8\BTABI_122\BTABI.DATA122',

'T:\ORACLE\QK1\SAPDATA7\STABD_25\STABD.DATA25',

'T:\ORACLE\QK1\SAPDATA8\STABI_15\STABI.DATA15',

'T:\ORACLE\QK1\SAPDATA7\BTABD_188\BTABD.DATA188',

'T:\ORACLE\QK1\SAPDATA7\BTABD_189\BTABD.DATA189',

'T:\ORACLE\QK1\SAPDATA7\BTABD_190\BTABD.DATA190',

'T:\ORACLE\QK1\SAPDATA7\BTABD_191\BTABD.DATA191',

'T:\ORACLE\QK1\SAPDATA8\BTABI_123\BTABI.DATA123',

'T:\ORACLE\QK1\SAPDATA8\BTABI_124\BTABI.DATA124',

'T:\ORACLE\QK1\SAPDATA8\BTABI_125\BTABI.DATA125',

'T:\ORACLE\QK1\SAPDATA8\BTABI_126\BTABI.DATA126',

'T:\ORACLE\QK1\SAPDATA7\UNDO_8\UNDO7.DATA8'

CHARACTER SET WE8DEC

;

former_member204746
Active Contributor
0 Kudos

ok, it looks fine,

please provide output of this command:

dir G:\ORACLE\QK1\SAPDATA1\SYSTEM_1\SYSTEM.DATA1