New answers tagged export
If you have mixed data, where some are double quoted and others are single, another option would be to load the complete data into a column and have a computed column in the same table that is running a function to strip out the unwanted characters from the source column. something like this: create table [xxxx] ( originalcol varchar(50) null, [$$derived] ...
Assuming that we are talking about dbms_scheduler jobs (rather than, say, jobs scheduled using the dbms_job package), you can use the dbms_metadata package to generate the DDL. Specifically, the dbms_metadata.get_ddl function. Something like SELECT dbms_metadata.get_ddl( 'PROCOBJ', <<job name>>, <<schema>> ) FROM dual should ...
To dump a database mysqldump -u root -p databasename > databasename.sql Dumping particular table alone then this would apply mysqldump -u... -p... mydb t1 t2 t3 > mydb_tables.sql
Set the text delimiter in the flat file reader properties to the double quote.
Probably best to: Import the entire CSV to a table using Import and Export Wizard. Run the query to pull the data you want from the table. Use the Import and Export Wizard to import to the other database. Clean up the CSV import, probably by truncating or deleting the table. Unless you want to use SSIS? Then you can design a package to do it easily ...
First, just to be certain we're covering our basis, this piece of code: EXP FILE = B.DMP OWNER(B) won't work. That's not a properly formatted EXP command. But assuming that you're using a properly formatted command, all that a user really needs is the EXP_FULL_DATABASE role, and they should be able to export any object in the database: SQL> create ...
Top 50 recent answers are included