/[email protected]File=d:\daochu.dmp owner= (System,sys)3 Exporting Tables Table1, table2 in the databaseExp system/[email protected]File=d:\daochu.dmp tables= (Table1,table2)4 Export the field filed1 in table table1 in the database with data beginning with "00"Exp system/[email protected]File=d:\daochu.dmp tables= (table1) query=\ "where filed1 like ' 0% ' \"The above is a common export, for compression I do not care, with WinZip to the DMP file can
Create Oracle directory, login with user SqlplusCreate or replace directory dpdata1 as '/a/b ';
Grant permission, dba Login SqlplusGrant Read,write on directory dpdata1 to user;
Exporting DMPA. Export by table, under Bin directory./EXPDP User/[email Protected] tables=table1,table2 dumpfile=expdp.dmp directory=dpdata1;B. Export by user./EXPDP User/[email Protected] schemas=user dumpfile=expdp.dmp directory=dpdata1;
Importing DMPA. Import the
Label:Import Library:Prepare beforehand:1. Ensure that Oracle is installed correctly on the Linux server2, Oracle client, capable of connecting to Oracle on server.Start Step:1, CREATE table space (table space is more common will give you a script to create a tablespace.) such as Createspace-for-windows.sql).2, login to the Linux server, such as SSH 192.168.20.22
Tags: File table RAC size login file replace CTO table space OracleFirst step: Create a backup file storage directory Create or replace directory Back_file as ' D:\app\yangxf\back_or_memery_file '; Create or replace directory name as ' D:\app\yangxf\back_or_memery_file '; Step two: Create a table space Create tablespace base_data datafile ' D:\app\yangxf\oradata\base_tablespace\BASE.dbf ' size 100M autoextend on next 50m; Create tablespace table space name (consistent with backup file tablespace
, and then perform the import operation to solve the problem of garbled characters in the data table.Problem 2 and Problem 3 workaround, modify the client character set, check the value of your system environment variable Nls_lang or registry hkey_local_machine-->software-->oracle under this branch to find Nls_lang key, Modify this key value and re-import the data.Finally we need to know what the character set should be changed to?Method One: Go to th
An error occurred while executing the import command to the Oracle database, which probably means that the service name could not be found in TNSLet's talk about the resolution step1: Enter Oracle user, use Cat to view the. bash_profile file, locate the Oracle_home variable2: Enter the Oracle_home/network/admin directory3: Check the Tnsnames.ora listening file, find the corresponding listener name, such as
Import using the cmd command
Enter cmd Direct input command
IMP username/password @ Listener path/Database instance name file= ' d:\ database file. dmp ' Full=y ignore=y
For example:
Imp Mislogin/mislogin@localhost/jfjoa file= "D:\data.dmp" Full=y ignore=y
using Oracle's Bin directory imp.exe import
Open Oracle Home DirectoryE:\app\shaoduo\product\11.2.0\dbhome_1\BINFind Impdb.exe for importRun wit
-execute the IMP, using the Indexs=n parameter to import objects other than index. Finally, go to Sql*plus, run the script you just edited, and build the index. This method is useful for importing index and constraints into the specified tablespace. 2. Change the default tablespace for the destination userThis is the way that people often ask questions. But the problem is not successful because of the lack of the following steps. first, recover the "UNLIMITED tablespace" permission for the desti
Before importing and exporting data, it is customary to check to see if our own machine can connect to a remote Oracle host, and the detection method is tnsping service_name. My machine is as follows:c:\users\zx>tnsping ORCLHost: lenovo-pc, service name: ORCLThe above operation is ping yourself, below we ping the remote host. How to use: Tnsping Ip/service_name, as follows:10.120. 56.203/ORCLHost and service names are marked by a red boxImporting data
One IMPDP import--Delete user if user already exists (can connect using Oracle's own sqlplus)sql> Drop user user_name cascadesql>/sql> drop tablespace user_tablespace including contents and Datafilessql>/--Create table space download sql> CREATE tablespace user_tablespace datafile ' User_tablespace. DBF ' SIZE 200M autoextend on NEXT 50M MAXSIZE UNLIMITED PERMANENT DEFAULT STORAGE (INITIAL 64K minextents 1 MAXEXTENTS 2147 483645) MINIMUM EXTENT 64K LOGGING ONLINEsql>/--Create usersql> CREATE USE
Exporting data using exp and EXPDP1.exp Export Data CommandExp gd_base/@192.168. 13.211 file=d:\export\gd_base.dmp log=d:\export\gd_base.log full=y2.EXPDP Exporting data(1) CMD window to connect to database, go to Sqlplus pageSqlplus Sys/[email protected]192.168. 13.211/oanet as Sysdba(2) Create a directory object (created with Administrator account login)' D:\FZB ';Once created, Exit Sqlplus.(3) Create the appropriate directory on the operating system , such as creating a folder in the D drive
Step1, first know that you want to import the DMP files in the database (such as AA.DMP) is that version of the export (export imported version to be consistent, of course, 11g files can export 10g dmp files).
Step2, in the Sqlplus command box with SYSDBA Administrator login, connect Sys/password as SYSDBA;
Step3, create large data table space created tablespace mytable datafile ' e:\mytables1.dbf ' size 20
I. Database DMP file ExportUnder the PL/SQL tool, select Export Tales, select all tables, and select the exported path.Second, database DMP file ImportCreate user table space;Create User: Grant DBA to AML;Execute Import Script: (premise: Windows Server has created TNS connected to database)IMP username/password @tns user file=***.dmp (
--------------------------------------------------------------------------------------------------------------- --------This afternoon, a colleague through the DOS import DMP file, has been in the Sqlplus interface constantly enter the user name, password, the interface has always prompted the protocol adapter error!Look at his anxious appearance, I went to look, suddenly silly, asked him how to import the exported data How to guide, he said that is a
Before creating a user name, you need to log on to the database as a user Administrator 1, to create a table space before creating a user:
The format is: Format: Create tablespace table name datafile ' data file name ' size table space;
For example:
sql> Create tablespace mytable datafile ' d:\myoracle\mytables1.dbf ' size 1024M segment space management auto;
If the table space is insufficient to import data, you can modify the table space as follows:
Sql>alter database datafile ' d:\myoracle\my
The project began to get the DMP file, the database is 10g, but did not guide the success, then want to possibly export the time with 11, decided to try.
Just the machine is 11 of the client, the results do not recognize imp command, to the installation directory under the Bin folder to see the implementation of the file without imp. May install the client when does not elect the manager to install.
What to do, copy one of the imp files from the oth
unlock accounts: Alter user account unlock
Login sys User: Sqlplus/as sysdba
Modify SYS User: ALTER user sys identify by password
Modify SYSTEM User: Alter user system identified by
Data export: 1 completely export database test, user Name System Password Manager exported to D:\daochu.dmp expsystem/ Manager@testfile=d:\daochu.dmp full=y 2 Export the table of the system user and SYS user in the database expsystem/ Manager@testfile=d:\daochu.dmp owner= (System,sys) 3 The tables in the
Tags: database export of Style file BSP error one Owner ImpNormal Import method (cmd command): First build table space, then build user IMP database name/database password @orcl file= database file path (can be dragged in auto-generated) full=y Statistics=none Common Export Method (cmd command): EXP database name/database password @orcl file= database file path (can be dragged in automatically generated) owner= (database name) Description: Because the data volume is too large in the import pro
Label:To delete a tablespace, delete the data file firstFor example, this exampleCREATEtablespace sthsgimgdb_space11 datafile'D:\ORACLEDATABASE\JinHuaDataBase\STHSGIMGDB_SPACE11_01'SIZE 1M Autoextend on NEXT50M MAXSIZE UNLIMITED,'D:\ORACLEDATABASE\JinHuaDataBase\STHSGIMGDB_SPACE11_02'SIZE 1M Autoextend on NEXT50M MAXSIZE UNLIMITED,'D:\ORACLEDATABASE\JinHuaDataBase\STHSGIMGDB_SPACE11_03'SIZE 1M Autoextend on NEXT50M MAXSIZE UNLIMITED,'D:\ORACLEDATABASE\JinHuaDataBase\STHSGIMGDB_SPACE11_04'SIZE 1M
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.