![]() ![]() 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. Therefore the command above returns an error.This is the first time I work with dump files, I am very beginner at this. My file contains some date but some of those are wrong date. Mysql -u username -p databasename < path/myfile.sql sql file to MySQL using this command line ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |