![]() How is it possible? Oracle says it doesn't exist and at the same time in the command prompt it says it exists. All dependent metadata and data will be skipped due to table_exists_action of skip So okay, I try to go further with the three steps and right after executing the step 1 I get this this error message :Įrror : ORA-39151: Table "SYSADM"."Table_1" exists. (b) All the way before wanting to drop the table created in sql developer, I get an error message saying that the table doesn't exist. Now when I do this I get two cases as well : Now until now nothing was blocking, I always found ways to keep going even if it's taking too much time. Here again, if you have any advice on how I can import the table without getting this column size error message it would be great. Step 3 : Then back to the command prompt to import only the data: impdp my_user/pswd DIRECTORY=Dir_Name DUMPFILE=CategorieA_.%U.dmp CONTENT=DATA_ONLY TABLES=SYSADM.table_1 LOGFILE=file_name Step 2 : then back to sql developer to extend the size of the column(s): alter table Table_1 modify (COL_1 VARCHAR2(50)) Step 1 : I import only the metadata : C:\> impdp my_user/pswd DIRECTORY=Dir_Name DUMPFILE=CategorieA_.%U.dmp CONTENT=METADATA_ONLY TABLES=SYSADM.table_1 LOGFILE=file_name So here what I do is that I go back to sql developer and drop (linked with #b below) the table_1 that has been created with the missing data and do the following in the prompt command : ORA-12899: value too large for column COL_1 (actual: 19, maximum: 18) ORA-02374: conversion error loading table "SYSADM"."Table_1" The table is successfully loaded : x lines loaded out of x ! ok nice nothing to say. Normally I need to create a tablespace, but with the information I have I don't find anywhere the name of the tablespace for the table I need to import, so what I do is that I write the import statement line and wait for it to return the error saying that it doesn't find the tablespace 'X' and after that I create the tablespace 'X' and I repeat the import statement line as follow (if you have an idea of how I can find the name of the tablespace I need to create without proceeding that way please let me know) : C:\"paths">impdp my_user/pswd TABLES=SYSADM.table_1 directory=Dir_Name dumpfile=CategorieA_.%U.dmp logfile=Log_Name SQL> CREATE DIRECTORY Dir_Name AS 'G:\Dir_Name' - This is where I copied all the dmp files and the logs SQL> alter session set "_ORACLE_SCRIPT"=true In the command prompt : C:\"path">sqlplus / as sysdba And what I need is to import individual tables into an Oracle Database. So we don't know which table is contained in which dump file. so we have something like that :ĭump files generated (the number of dmp files depends on the size of the data): Let's continue the reasoning with one category that we will call A.įor the A category, he generated dump files for the results of all the queries he made. ![]() There are several categories (let's say HR, Finance, Sales, etc.) and for each category, he made SQL queries (where each query is related to one table). This is how my client generated the dump files: I have DUMP files that contain tables and I need to import those tables to an Oracle database. This is the first time I work with dump files, I am very beginner at this. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |