Home » RDBMS Server » Server Utilities » Export view
Export view [message #72092] Thu, 06 March 2003 01:52 Go to next message
pennie
Messages: 7
Registered: February 2003
Junior Member
I have submitted some jobs to oracle database and I can view the details at user_jobs. I think this is a view table.
Can I export sys.user_jobs into a dump file so that I can import it to the backup server?
Is there anyone can guide me on this??
Thanks in advance
Re: Export view [message #72093 is a reply to message #72092] Thu, 06 March 2003 06:09 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
-- any object owned by sys by default(created when database is created) is not exported.
-- but u can create a base table and do the export
-- but, ORACLE HIGHLY RECOMENDS NOT TO HAVE ANY CUSTOM OBJECTS IN SYS/SCHEMA.
-- so u can create the backup table as shown in another schema than SYS/SYSTEM. ( I HAVE USED SYS -- SCHEMA.DONT DO THAT.
-- 
-- but, WHAT IS WHOLE USE?
-- why is it required to backup the user_jobs?
-- 

Microsoft Windows 2000 [[Version 5.00.2195]]
(C) Copyright 1985-2000 Microsoft Corp.

C:>exp sys/sys tables=(dba_tables)

Export: Release 8.1.6.0.0 - Production on Thu Mar 6 07:46:42 2003

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

About to export specified tables via Conventional Path ...
EXP-00011: SYS.DBA_TABLES does not exist
Export terminated successfully with warnings.

--
-- create a table...from the view
--

sys@itloaner1_local > create table backup_dba_tables as select * from dba_tables;

Table created.

sys@itloaner1_local > host

C:>exp sys/sys tables=(backup_dba_tables)

Export: Release 8.1.6.0.0 - Production on Thu Mar 6 07:49:05 2003

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table              BACKUP_DBA_TABLES        289 rows exported
Export terminated successfully without warnings.

C:>

Previous Topic: While export error comes EXP-00008:Oracle error 1406 encountered
Next Topic: copy a datafile from one instance to another
Goto Forum:
  


Current Time: Wed May 15 20:46:34 CDT 2024