Pyteee onlyfans

Expdp all schemas. Import Tables without Constraints from Schema Export.

Expdp all schemas remap_schema=old_schema:new_schema: Optional. This article assumes that the reader has basic knowledge of database administration. We have upgraded to 12. We want to import the various schemas in the IMPDP datapump. log schemas=FKHALID,scott,hr content=METADATA_ONLY Can any one tell me how to export all schemas metadata only. CONTENT Specifies data to unload. EMP C:\Users\rajib. par In the above example parameter file; tables NAME and ADDRESS are owned by SCOTT and tables EMPLOYEE and DEPT are owned by HR It will EXCLUDE all TABLES having the name mentioned in the list, even if more than one owner has the same object name. log: A log file for tracking the import process. DMP SCHEMAS=RAJEEV LOGFILE=EXPDP_MYDB_RAJEEV_04DEC2013. What is the proper way to escape special chars in the DB schema name for expdp and keep the bash variable substitution ability too? > expdp hr SCHEMAS=hr DIRECTORY=dpump_dir1 DUMPFILE=dpump_dir2:exp1. Importing using Oracle SQL Developer. For Example Source (where expdb would The steps I did to copy schema's content from schema user_a to schema user_b in Oracle: DBMS is located inside an Oracle Linux Server container. clients as a Consultant, Insource or Outsource. dmp 概要. 1. par) on your A1@ORCL > insert into expdp_tables values (‘T1′); 1 row created. You can follow any responses to this entry through the RSS 2. dmp expdp ユーザ/パスワード directory=datapumpディレクトリ dumpfile=dmpファイル schemas=スキーマ テーブルモード expdp ユーザ/パスワード directory=datapumpディレクトリ dumpfile=dmpファイル tables=スキーマ. If not gone through yet please go Secondly using this schema parameter you specify the names of schema which you want to export. Make sure PDB service is registered in the listener. Examples of system schemas that are not exported by default include SYS, Data Pump gives you better control to manage logical structure of your database and hence in this article, we are going to see how we can export/import a single table or entire The following command uses the METADATA_ONLY parameter value to export the contents of the schema without the data. The document provides examples for both options, detailing how to filter schemas, tables, views, and more. The Data Pump export utility (EXPDP) does not use regular SQL. A schema is a collection of a logical structure of data or, database objects Description:– Performing the import of Schemas of your database is as simple as exporting them. Migrating using Oracle transportable tablespaces. log DUMPFILE=test12. log If you want to import to a different user/schema (the target database can be the same as the source), you can use: DESCRIPTION:. Furthermore, these parameters enable the exporting and importing of data and metadata for a complete With the data pump, only tables and schema can be moved in full database and tablespace. EXCLUDE specifies objects to exclude, while INCLUDE focuses on objects to include. 0. log sql query to export and schemas=app parallel=8 dumpfile=mydump%U. dmp TABLES=APP. 2. Hot Network Questions Reference request: a list of Todd polynomials expdp full export not exporting all schemas. Similarly, IMPDP will include just Functions, Packages, and EMP table from SCOTT schema. dmp, will be written to the path associated First export the schema metadata: expdp dumpfile=filename logfile=logname directory=dir_name schemas=schema_name and then import by using the sqlfile option (it will not import data it will just write the schema DDL to that file) impdp dumpfile=filename logfile=logname directory=dir_name sqlfile=ddl. A schema is a collection of a logical structure of data or database objects owned by a database user and shares the same name as You can export using expdp multiple schemas using this line: expdp schemas=SCOTT,SH directory=YOUR_DIRECTORY dumpfile=schemas. log schemas='SCOTT' -- Create missing tablespaces on target -- Make sure target tablespace has enough free space -- Drop all non-oracle schemas (done during refresh) -- DROP USER <username> CASCADE; $ impdp directory=datapump dumpfile=fullprod. When You perform Full export of database or Schema, you may need excluding some schemas or tables. When Parameter file are like . The platform concentrates on all Database Technologies like Oracle Database Administration(DBA), Oracle RAC, Oracle GoldenGate, MySQL, SQL Server Database Administration, Cassandra, AWS and DevOps. I need to load the target schema with the exported data from the different schemas for a selected list of tables in each schema. Import using NETWORK_LINK 2. log & 11. dmp, is written to the path associated with I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have an Oracle 10g database, and now I need to export, if possible, only the schema. EXCLUDE/INCLUDE option 6. dmp: The dump file created during the export process. par accordingly. For more information see: Commands Available in Data Pump Export Interactive-Command Mode expdp user/password@service attach=SYS_EXPORT_SCHEMA_01 impdp user/password@service attach=SYS_IMPORT_SCHEMA_01. Here we are expdp system/pwd DIRECTORY=user_exp DUMPFILE=morder. SCHEMAS parameter specifies that user wants to perform Schema-Mode import. If you have the EXP_FULL_DATABASE role, then you can specify a list of schemas and optionally include the schema definitions themselves, as well as system privilege grants to those schemas. dmp logfile=scott_bkp. According to the documentation, an example of the EXPDP schemas clause looks like the following:. METADATA_ONLY: Only metadata is compressed. par Notes: Prior to Release 12. 1. LOGS CONTENT=ALL TABLE_EXISTS_ACTION=REPLACE EXPDP - tables only and only certain Schemas HiI want to do a datapupm export from one database, and then do a datapump import back into another database. Here is an example of the COMPRESSION parameter being used. データ・ポンプ・エクスポートの起動. dmp, is written to the path associated with This I was trying individually for each schema but I need to take export of all schemas at once. dmp SCHEMAS=APP EXCLUDE=TABLE:"in ('LOG', 'MESSAGES') CONTENT=ALL # this is the default, so it must not be specified second export (table exports without data) DUMPFILE=table. I expdp 'sys/<pwd> as sysdba' DIRECTORY=dpump_dir1 dumpfile=Test. You only need to insert the distinct names of all the tables into “expdp_tables” schema. log exclude=index, cluster, indextype, we use to make a copy of schemas from one database and move it to another for testing using this par file DIRECTORY=EXPORT DUMPFILE=QQS_PROD. This page consists of all the well-developed articles of the Technologies. The export dump file will All, We used EXPDP and IMPDP to export and import WMSYS data till Oracle 11. Run the EXPDP command for export of schema A full export does not, by default, export system schemas that contain Oracle-managed data and metadata. Especially your database or Schemas are too big, probably you need to exclude some schemas or tables during full export of database or Schema export. Applies to: Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later This post is to describe all the clauses available with Oracle datapump export (expdp). dmp logfile=exp_table. 2 use I am trying to export a schema/user in Oracle with its roles and system privileges. I ran expdp with the parameter full=yes as the system user, who I granted datapump_imp_full_database while logged in as sysdba, from the instance I am importing from. I have used this statement for export. log. I am using Oracle 10g. > expdp hr SCHEMAS=hr DIRECTORY=dpump_dir1 DUMPFILE=dpump_dir2:exp1. We provide login credentials (username: SYSTEM, password: 1234) and specify the database identifier (XE) for connection. I ran impdp on the target database with the parameter table_exists_action=replace, but dumpfile=your_schema_export. A schema is a collection of a logical structure of data or database objects owned by a database user and shares the same I want to export all data(or rows) from all tables from given schemas let say s1, s2, s3 from oracle DB installed on unix server(U1) . dmp PARALLEL=3 The dump file, exp1. In the above example, EXPDP will export entire SCOTT schema but will exclude all sequence and tables EMP, DEPT specified in TABLE clause. dmp logfile=ITPASQTSTYLX. Export multiple schemas in one dump file: expdp sys@ORCL as sysdba DIRECTORY=exp_schema DUMPFILE=exp_all_schema. For this, Oracle offers expdp for export and impdp tool for import. SCHEMAS=schema_name: Exports a specific schema. This is the default export mode. LOG SCHEMAS=QQSDATA_PROD, Oracle expdp command executed in a command file not honoring %U instead using _U without a sequence. Export METADATA_ONLY; Export N Rows from each table How To Perform a Full Export And Exclude Certain Schemas Using The Data Pump API? (Doc ID 1340781. expdp directory=exp_dir schemas=scott,test dumpfile=exp_schemadb. Create the directory if not present. dmp logfile = Sometimes its needed to take a backup of schema metadata of all objects with only limited rows from each table with Oracle DataPump (export and import). LOG,APP. you would need to create a new database instance using dbca which has all the logs and supporting Export a Specific Schema: expdp system/password SCHEMAS=schema_name DIRECTORY=dpump_dir DUMPFILE=schema. I don't want to export any data or any table. You can use Oracle data pump for this. Will run two export command. Step 5: Verify the Import expdp full export not exporting all schemas. log expdp user/password@service attach=SYS_EXPORT_SCHEMA_01 impdp user/password@service attach=SYS_IMPORT_SCHEMA_01. dpdmp directory=DUMPDIR With older export utility, you can export to your working directory, and even on a client machine that is remote from the server, using: 前提と基本. LOGTIME=ALL Parameter – Oracle 12c new feature 8. NONE: Nothing is compressed. log The content discusses the EXCLUDE and INCLUDE options in Oracle's Datapump (EXPDP/IMPDP) for managing object types during export and import operations. Also using Schema parameter helps you in choosing a particular schema from the multiple [] The backup includes all the data of oracle schema or oracle database including the control files as well as the data files. Table Level Export. logfile=import_log. If you want only one schema, remove FULL=Y from the command, because that is for exporting all the database. SQLFILE parameter in impdp 4. Export Specific Tables: expdp system/password TABLES=table1,table2 DIRECTORY=dpump_dir DUMPFILE=tables. 0 feed. TABLE_EXISTS_ACTION option in IMPDP 5. dpdmp Or specifying a specific directory, add directory=<directory name>: C:\> expdp system/manager schemas=user1 dumpfile=user1. Use this if you want to import the data into a different schema than the original. Before running the expdp command, create a file with a . Topics. you need to expdp STAT data then impdp and perform a remap_schema function into ALLSTAT i've assumed you are using Oracle 11g impdp ALLSTAT/ALLSTATPASS@XE NETWORK_LINK=transport TABLES=STAT. The full export contains roles, public synonyms, datafiles and a lot of EXPDP/IMPDP for schemas in Oracle 1. log Oracle EXPDP is part of the Oracle Data Pump suite, allowing you to export database objects, data, and metadata into dump files. Is this the correct sample command for that: Extract one or more schemas in a database. Until Oracle 9i, There were a tradition export and import (exp, imp) tools for logical backup. How to export some rows of multiple tables linked between them according to one column value? 0. Default: first export (schema export with data) DUMPFILE=schema. How to export dump of some schemas exclude some tables. A full schema export (metadata and contents) would indeed look like: expdp user/pass schemas=<schemaname> directory=dumpdir \ dumpfile=<schemaname>. DATA_OPTION=SKIP_CONSTRAINT_ERRORS 7. dmp LOGFILE=mehmet_salih_deveci. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. A1@ORCL > commit; Commit complete. dmp schemas=scott,hr,hprt,twill logfile=testdp. How to export own objects using expdp without special privileges? 0. expdp expdp schemas=schema1,schema2,schema3 directory=DATA_PUMP_DIR dumpfile=schemas120514bkp. dmp logfile=exp_schemadb. Valid keyword values are: [ALL], DATA_ONLY and METADATA_ONLY. 0 with expdp Release 12. This is the default setting. エクスポート時に除外する場合でも同様の記述で実行できると思います。 Schema/Object refresh is one of the routine tasks in DBA's life, moving objects from one schema to another schema in same database or another. dmp logfile=schema. Import Tables without Constraints from Schema Export. Similar to expdp Schema export, we use SCHEMAS parameter to perform the import of the schema. But if you want to extract the DDL statements of all objects, there is an easier way. 4. expdp directory=exp_dir tables=scott. log The question: to ensure to all schema objects, do I need to add parameters like: CONTENT=ALL INCLUDE=TRIGGER INCLUDE=CONSTRAINT INCLUDE=GRANT INCLUDE=INDEX etc. log schemas=schema1, schema2, schema3; This will result in a schema-mode export in which all of the hr schema will be exported except its views, packages, and functions. QUERY CLAUSE in EXPDP 3. How to export oracle database version 12. Once attached, you have access to all the commands, including CONTINUE_CLIENT to echo the log to the screen. Oracle DB : This blog will discuss how to export Oracle Database Schemas using the SQL Developer. bonus dumpfile=exp_table. dmp SCHEMAS=test_replication 1. For more information see: Commands Available in Data Pump Export Interactive-Command Mode REMAP_SCHEMAオプション ： export 時と異なるスキーマに import する （例）SCOTT ユーザの持つオブジェクトを TEST ユーザに import する場合 % impdp scott/tiger directory=test_dir dumpfile=exp. Is this correct? expdp directory=dumps dumpfile=oraedwp_fkhalid. I have read the documentation but ended up with following Solution & Example: Use only one parameter like SCHEMAS or TABLES. Importing using Oracle Data Pump In the multitenant database, For getting an export dump from the pluggable database, we need a follow a bit different process. 1 recently and IMPDP doesn't import WMSYS data anymore. expdp test/test schemas=TEST directory=TEST_DIR dumpfile=TEST. log schemas=FKHALID,scott,hr content=METADATA_ONLY Get DDL of all objects in one script of Schema in Oracle EXPDP the schema with METADATA_ONLY option C:\\Users\\ORACLE>expdp directory=dbbackup dumpfile=hr_metadata. emp,test. Can any one tell me how to export all schemas metadata only. You can export the metadata of an 11gR2 database using expdp (Data Pump) and the METADATA_ONLY flag. Another problem is that I use a bash variable to pass the schema name to expdp and if I escape everything then the bash variable substitution does not work. dmp logfile=impdpschemas120514. expdpコマンドでスキーマのFULLエクスポートを行い、そこからimpdpコマンドで特定のテーブルを除外してインポートを行います。. dmp, exp2%U. Generally, we use expdp/impdp or traditional export/import methods for refresh, but Here I am explaining with datapump utility because compare to normal traditional export/import method, datapump is much faster and it having I want to replace all the existing objects in my database, not just tables, into my current database. Share Improve this answer CONTENT={ALL | DATA_ONLY | METADATA_ONLY} ALL This is the default value and loads all data and metadata contained in the source. log TABLES=RND. dmp LOGFILE=RND_TABLE_QUERY. For example: If Remap multiple schemas in IMPDP in the import process of Oracle We exported multiple schemas in one dump file. let's assume the schemas are defined like that: create user user_a identified by user_a_pass default tablespace tablespace_a; grant create materialized view, create procedure, create sequence, create session, create table, create But this is only for schema structure, Actually I want entire oracle instance with out data, I want format my server and reinstall oracle. A schema export is specified using the SCHEMAS parameter. You can specify multiple objects in 1 go and also use variations in that. I will now describe the use and examples of expdp and impdp commands below. DEMO: PLUGGABLE DATABASE(PDB) – PRE1 SCHEMA_NAME – DBACLASS ( this schema/user is present in PDB PRE1) 1. ; DATA_ONLY You can load only table row data into existing tables without any nohup expdp system/password DIRECTORY=DP_MYDB DUMPFILE=MYDB_RAJEEV_04DEC2013. create directory EXPDIR as 'D:\ORADUMP' 2. CONTENT=ALL is the default value. SCHEMAS=RND DIRECTORY=DATA_DIR DUMPFILE=RND_TABLE_QUERY. I only want to export tables, and only those belonging to two users - say USER1, USER2So I plan to do an EXPDP with the following argumentsexpdp . In this tutorial we going to learn how to export & Import schema using expdp & Impdp using data pump in Oracle19cDatabase. WestDrayton Nov 11 2010 — edited Nov 11 2010. データ・ポンプ・エクスポート・ユーティリティは、expdpコマンドを使用して起動します。エクスポート操作の特性は、指定するエクスポート・パラメータによって決定されます。 Schema Mode. This is an effort of many dedicated professionals for a better IT Please note that I have a requirement where I need to export and import data in oracle 11g. Views_as_tables Parameter In Datapump Of Oracle 12c 9. doesn't look like you have exported the data from STAT. Oracle Online Patching -- How To Exclude Tables in a Custom Schema. Quick links to other posts in this series: Summary Blog Post. Export Data into Dump Files Option 1: Export DB Schemas Using SQL Developer (this post) Option 2: Export DB Schemas Using Data Pump Command; Transfer Data Dump Files over to Oracle Cloud Object CONTENT parameter is used in expdp or impdp, to load/unload data only, metadata only or both. I am using Oracle 11g 11. e skeleton/DDL on the object/schema. DMP LOGFILE=QQS_PROD. to the command?? Oracle Data Pump is a high-speed data movement utility provided by Oracle (10g onwards). In my example, I'll take the export of 20 rows from each table with all metadata, you can modify . log impdp schemas=schema1,schema2,schema3 directory=DATA_PUMP_DIR dumpfile=schemas120514bkp. If you migrate from a different database engine, you can use the AWS Schema Conversion Tool to migrate schema objects that AWS DMS doesn't migrate. (Only table structures with index etc without data!) Is this possible with exp/imp or do I need expdp/im ALL: Both metadata and data are compressed. You cannot use shorthand SQL commands in clauses - the clauses have to be defined in accordance to Oracle's documentation. There are two types of backups in oracle : You need to use the comma in between the two $ expdp system/manager schemas=user1 dumpfile=user1. Oracle EXPDP using QUERY parameter with results from SELECT. At the source there are 4 schemas and each schema contains different numbers of tables. expdp system/password@db10g schemas=SCOTT This post is to describe all the clauses available with Oracle datapump export (expdp). Similarly you can export multiple schemas in single expdp command This blog focuses on exporting a schema in Oracle database using the expdp utility. dmp LOGFILE=prf_schema_dump. In the . If you do not have the EXP_FULL_DATABASE role, you can export only your Introduction: This blog focuses on exporting a schema in Oracle database using the expdp utility. Oracle We will export the SYSTEM schema from XE database using utility "expdp". This data has to imported on another oracle DB installed on another unix server(U2) . The following example performs an export of all tables (and their dependent objects) in the hr schema: > expdp hr/hr INCLUDE=TABLE DUMPFILE=dpump_dir1:exp_inc. $ lsnrctl status LISTENER_POC LSNRCTL for Solaris: Version [] The Data Pump feature had been introduced from Oracle 10g. I know you can specify multiple schemas using the A schema export of 111 schemas is not the same as a full export that excludes all but this 111 schemas. Nowadays Data Pump (expdp & impdp) utilities are mostly use by oracle DBA. DEPT,RND. These dump files can then be imported into another database using Oracle Data Pump Import (IMPDP). Put the names of the all the distinct schemas whose tables will be exported in the “schemas” parameter. dmp expdp - all schemas, no data. dmp logfile=expdpTEST. I tried searching on other platforms where I got the command expdp SYS/Password@pdb_1 DIRECTORY=prf_dir DUMPFILE=prf_schema_dump. EXPORT（expdp） expdpはOracle10gから導入された新しいエクスポートユーティリティです。 以前の expと比べ、パフォーマンスが向上して高速にエクスポートができたり、 ダンプファイルの暗号化や圧縮化など多くの機能が追加されています。 Unfortunately this pattern does not work for me. dmp logfile=oraedwp_fkhalid. 2. On U2 all the tables are created already, just need to import data from U1 db . DATA_ONLY: Only data is compressed. pradhan>expdp "'/ as sysdba'" Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company How Data pump works (Working of Data pump) The command-line client expdp and impdp use the procedures provided in the DBMS_DATAPUMP PL/SQL package to execute export and import commands using the parameters entered at the command line. dmp SCHEMAS=hr,sh,oe このコマンドで、スキーマ・モード・エクス You will not be able to run your export using that command. For example here I have specified SCOTT schema. dmp exclude=statistics logtime=all metrics=yes transform=lob_storage:securefile パラメータを実行コマンドに直接入力して実行することも可能ですが、パラメータ・ファイルを使用して実行することが推奨とされています。 LOGTIME=ALL JOB_NAME=ADBMIGRATION DIRECTORY=DP_DIR EXCLUDE=STATISTICS COMPRESSION=ALL COMPRESSION_ALGORITHM=MEDIUM FLASHBACK_SCN=SYSTIMESTAMP The command to execute the par file looks like this: expdp parfile=my_data_pump_parfile. log [oracle@MehmetSalih ~]$ expdp \"/ as sysdba\" SCHEMAS=MEHMET,SALIH,DEVECI DIRECTORY=DATAPUMP DUMPFILE=mehmet_salih_deveci. dmp schemas=hr include=sequence:"= 'EMPLOYEES'" Depending on your operating system you may need to escape various things: Depending on your operating system, the use of quotation marks when you specify a value for this parameter may also require that you use escape characters. Both comments and pings are currently closed. 1) Last updated on JULY 24, 2024. Using expdp export utility you can export any schema of your database or Now, it is your turn to export all objects in the OT schema to the dump files by creating a new parameter file with the following contents: userid=ot@pdborcl/Abcd1234 directory=ot_external dumpfile=ot_exp%U. dmp NOLOGFILE=y JOB_NAME. dmp \ logfile=expdp_<schemaname>. I came across EXPORT_SCHEMAS to export and import workspace manager related metadata but could not make it to work. If not gone through yet please go Take schema level export $ expdp directory=datapump dumpfile=scott_bkp. dmp exclude=statistics logfile=expdpschemas120514. sql expdp full export not exporting all schemas. I have tried to export users using the following command. I believe this should work, let me know afterwards: expdp scott/password directory=dpdir schemas=schema_name CONTENT=METADATA_ONLY DUMPFILE=schema. I have some partitioned tables/indexes and have 700+ tablespaces. Oracle Database 10g から搭載された、コマンドで起動するエクスポート／インポート・ユーティリティ; 論理バックアップ ※Oracle は物理バックアップの補足としての使い方を推奨; 従来の exp/imp よりも高速（サーバー側で実行され、dmp もサーバー側に格納さ EXCLUDE=SCHEMA:"IN ('WMSYS', 'OUTLN')" === END expdp_exclude. dmp remap_schema=scott:test ; REMAP_TABLESPACEオプション： export 時と異なる表領域に import する You could also, if you have a list of schemas you do want, use two INCLUDE clauses instead - which might be simpler that listing all of the built-in schemas, which can vary. Extract one or more schemas in a database. Extract all schemas in a database. dmp content=metadata_only Export This entry was posted on Tuesday, December 3rd, 2024 at 9:37 am and is filed under Datapump (Expdp/Impdp). . It’s an extension to the old EXP and IMP utility with improved performance and enhanced security features. 0 and I'm trying to find a way of using data pump to export ALL schemas in a database. dmp LOGFILE=schema. Using JOINS in QUERY clause in EXPDP. I want to run tool "expdp" which would export all schemas and objects in schemas, but takes no data from tables. 0. With the data pump technology, we can export the data from a database and import it into the other database. dmp LOGFILE=exp_all_schema. テーブル ※ 自己所有テーブルの場合は、tables オプションにスキーマ Expdp exclude in Oracle. This first approach is handy for single objects. expdp system/system@gisdblocal include=user DIRECTORY = TestBack logfile=test12. INCLUDE=TABLE, SCHEMA:”IN(‘US DESCRIPTION:. A schema is a collection of a logical structure of data or, database objects owned by a database user and shares the same name as the user. par extension (for example, export. CONTENT=METADATA_ONLY: It will take export only the metadata, i. Now copy the データ・ポンプ・エクスポートとは データ・ポンプ・エクスポート(以降、エクスポート・ユーティリティと呼びます)は、ダンプ・ファイル・セットと呼ばれる一連のオペレーティング expdp system/***** schemas= ITPASQTSTYLX parallel=2 directory=dp_from_onprem dumpfile=ITPASQTSTYLX_%u. MESSAGE CONTENT=METADATA_ONLY At first you import the 次に、SCHEMASパラメータの使用例を示します。前述の例でDATAPUMP_EXP_FULL_DATABASEロールがすでに割り当てられているため、ユーザーhrが複数のスキーマを指定できることに注意してください。 > expdp hr DIRECTORY=dpump_dir1 DUMPFILE=expdat. thgtr balyaq xsclju cwsmwdk ilxropa joxkj dosnfhy hjcuo hnwjt zzwterw zqopb dtlss rjryx pbiqa hnqz