Importing and Exporting Oracle Data for DBAs

Focused View

Pankaj Jain

4:03:15

14 View

01. Course Overview

01. Course Overview.mp4

02:18

02. Overview

02. Module Overview.mp4

00:40

03. Course Overview.mp4

03:17

04. Prerequisites.mp4

00:19

05. Audience.mp4

00:54

06. Tools.mp4

02:11

07. Summary.mp4

00:25

03. Understanding Oracle Data Pump

08. Module Overview.mp4

01:55

09. Features.mp4

02:26

10. Components Oracle Data Pump Execution.mp4

02:11

11. Data Pump Files.mp4

02:05

12. Master Table.mp4

01:19

13. Basic Command Line Parameters.mp4

02:07

14. Scenario.mp4

00:54

15. Demo-expdp impdp.mp4

04:12

16. Oracle Data Pump Modes.mp4

06:02

17. Data Transfer Methods.mp4

04:59

18. Moving Data Between Different Database Versions.mp4

05:03

19. Summary.mp4

01:17

04. Moving Schemas Metadata

20. Module Overview.mp4

01:17

21. Schema Mode.mp4

04:31

22. LOGFILE.mp4

00:41

23. SQLFILE.mp4

01:46

24. ESTIMATE ESTIMATE ONLY.mp4

01:25

25. REMAP SCHEMA.mp4

02:21

26. TRANSFORM Clause.mp4

02:16

27. Demo-Schema Export Import.mp4

07:54

28. CONTENT Parameter.mp4

01:36

29. Demo-Moving Just the Schema Metadata.mp4

02:21

30. Demo-Moving Just the Schema Data.mp4

02:45

31. Disabling Enabling Constraints.mp4

02:21

32. Demo-Disabling Enabling Constraints.mp4

04:02

33. Disabling Enabling Triggers.mp4

00:48

34. Demo-Disabling Enabling Triggers.mp4

03:08

35. EXCLUDE INCLUDE Parameters.mp4

03:21

36. Demo-EXCLUDE INCLUDE Parameters.mp4

04:11

37. Moving Multiple Schemas.mp4

01:24

38. Demo-Moving Multiple Schemas.mp4

02:17

39. Summary.mp4

01:24

05. Moving Specific Tablespaces Suspending Resuming and Monitoring Jobs

40. Module Overview.mp4

01:14

41. TABLESPACES Parameter.mp4

03:11

42. REMAP TABLESPACE.mp4

01:12

43. Demo-TABLESPACES Parameter.mp4

07:17

44. Monitoring Oracle Data Pump Jobs.mp4

02:20

45. Attaching to a Job.mp4

01:39

46. Getting Job Information.mp4

00:58

47. Interactive Mode Commands.mp4

01:25

48. STOP JOB.mp4

00:58

49. START JOB.mp4

01:02

50. CONTINUE CLIENT STATUS.mp4

00:38

51. KILL JOB EXIT CLIENT.mp4

00:57

52. PARALLEL.mp4

00:40

53. FILESIZE.mp4

01:23

54. ADD FILE.mp4

01:25

55. Demo-Interactive Mode.mp4

07:02

56. Summary.mp4

00:57

06. Moving Specific Objects and Filtering Data

57. Module Overview.mp4

01:23

58. TABLES Parameter.mp4

04:05

59. TABLE EXISTS ACTION.mp4

02:22

60. TRANSPORTABLE Parameter.mp4

01:14

61. Exporting Importing Partitions.mp4

01:30

62. REMAP SCHEMA Parameter.mp4

00:51

63. CONTENT Parameter.mp4

01:02

64. Demo-Exporting Importing Tables.mp4

04:21

65. Metadata Filters.mp4

04:36

66. QUERY SAMPLE Parameters.mp4

03:30

67. Demo-Data Filtering.mp4

04:25

68. Summary.mp4

01:04

07. Moving Databases Transportable Tablespaces

69. Module Overview.mp4

01:16

70. Transporting Data.mp4

02:34

71. Full Transportable Export Import.mp4

06:05

72. Database Transport Over Network.mp4

02:18

73. Transportable Tablespace Mode.mp4

01:08

74. Transportable Tablespace-Use Cases.mp4

01:23

75. Transportable Set.mp4

03:51

76. Steps for Transportable Tablespace Mode.mp4

01:26

77. Transportable Tablespaces-Limitations.mp4

01:17

78. Transportable Tables.mp4

00:39

79. Steps for Transportable Tables.mp4

02:19

80. Steps Using NETWORK LINK.mp4

00:53

81. General Limitations While Transporting Data.mp4

02:25

82. Summary.mp4

01:08

08. Configuring Advanced Import and Export Parameters

83. Module Overview.mp4

01:09

84. COMPRESSION Parameter.mp4

02:52

85. Data Masking.mp4

02:16

86. Encryption.mp4

03:40

87. Skipping Tables with Unusable Indexes.mp4

01:00

88. FLASHBACK SCN FLASHBACK TIME.mp4

02:17

89. Credentials.mp4

01:25

90. Summary.mp4

01:18

09. Working with Oracle Multitenant Architecture

91. Module Overview.mp4

00:57

92. Oracle Multitenant Architecture.mp4

01:33

93. Data Pump with CDBs.mp4

00:29

94. Moving a Non-CDB to a PDB.mp4

00:54

95. Considerations.mp4

01:22

96. Move PDBs Within or Between CDBs.mp4

00:48

97. Summary.mp4

00:47

10. Working with Oracle Autonomous Database in the Cloud

98. Overview.mp4

02:06

99. Demo-Getting Started with Oracle Cloud.mp4

02:14

100. Demo-Creating Oracle Autonomous Database.mp4

03:21

101. Demo-Connecting to the Database and Setting It Up.mp4

03:32

102. Demo-Installing Oracle Instant Client.mp4

04:39

103. Demo-Exporting to Directory.mp4

02:38

104. Demo-Creating a Bucket for Oracle Object Store.mp4

01:56

105. Demo-Creating Credential Object.mp4

01:37

106. Demo-Moving Export Dump Files to Oracle Object Store.mp4

02:04

107. Demo-Exporting Directly to the Oracle Object Store.mp4

01:01

108. Demo-Importing to Oracle Autonomous Database from Dump Files in Oracle Object Store.mp4

02:19

109. Demo-Importing in Oracle Autonomous Database from Dump Files in Directory.mp4

02:05

110. Summary.mp4

01:10

Description

As a DBA, you are constantly asked to create test schemas from production and sometimes move the entire database. In this course, you'll look at the Oracle Data Pump, a powerful tool which can help you perform these tasks easily and effectively.

What You'll Learn?

DBA are often asked to quickly create test schemas from production, or to move schemas, tablespaces, and tables between instances. In this course, Importing and Exporting Oracle Data for DBAs, you will learn how to move data and metadata between Oracle instances easily and effectively. First, you will explore the Oracle Data Pump tool, which is a very powerful and feature-rich tool. It provides a very fine-grained control for whatever you want to move, from the whole database to just a table with specific rows. Next, you will look at how to move schemas, tablespaces, and even the entire database. You will also explore how to move specific objects and the rich filtering capabilities of this tool. Finally, you will get a high-level overview of the transporting option to move data, which increases the performance significantly, and also briefly touch upon how Oracle Data Pump works with the Multitenant Architecture introduced with Oracle 12c. By the end of this course, you'll have a strong knowledge of importing and exporting Oracle data using the Oracle Data Pump.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Oracle SQL

Database Programming

Pankaj Jain

Instructor's Courses

Pankaj Jain is an experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development. He has worked on an array of technologies, with focus on Oracle at the database layer and Java at the web tier. He is a certified Oracle 11g DBA. He lives in Seattle with his wife Simita and boys Ronit and Rohak. When he is not playing with technology, he likes spending time with his kids, travelling and doing photography.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.