Tag Info

New answers tagged

0

When it comes to software downloads for production use, the Oracle sites, thankfully, are a little less of a maze - provided that you are familiar with the entrance. You can find the latest media packs for production use on the Oracle Software Delivery Cloud After logging in and accepting terms and export restrictions, select Oracle Database and Linux ...


2

This Powershell script should be able to solve most of your issue. I use a system table select to get my list of tables, then BCP to export all the data. The challenge is exporting your BLOBs. This script will export those as character data, which may not be useful to you in your situation. Import-Module sqlps -DisableNameChecking $outputdir="C:\TEMP" ...


0

Pure MySQL, be sure to correct it for your desired filepath /tmp/filenames.log: (Thanks Phil for the select query) "SELECT meta_value AS filename FROM wp_posts p, wp_postmeta pm WHERE p.id = pm.post_id AND p.post_type = 'attachment' AND meta_key = '_wp_attached_file' INTO OUTFILE '/tmp/filenames.log' LINES TERMINATED BY '\n';"


0

Looking at the Wordpress ERD and googling a little, attachments are in the wp_posts table, as follows: select * from wp_posts where post_type = 'attachment'; Join with wp_postmeta, which is a key=>value store, on meta_key = '_wp_attached_file' to get the filename (meta_value). So we end up with: select meta_value as filename from wp_posts p, ...


0

Try changing the tables parameter to this. You only need parentheses when you have more than one table. TABLES='SYSTEM_PARAMETERS' \ $ exp tables=system.plan_table file=plan_table.dmp statistics=none Export: Release 11.2.0.2.0 - Production on Tue Feb 17 08:59:05 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. ...


0

Seems like more often than not I run into issues trying to export to excel using the SSMS import/export wizard and I've never taken the time to learn and understand the quirks. This doesn't necessarily answer your question, but might be a viable alternative. Instead of exporting to excel, consider importing into excel. This YouTube video appears to ...


0

I just wanted to chime in and share what got me past this error. In my case (Ora 11.2.0.3 on Win 7) I found I needed the trailing '\' in my directory path. Replaced: CREATE OR REPLACE DIRECTORY dpump_dir AS 'C:\Data\SID' With: CREATE OR REPLACE DIRECTORY dpump_dir AS 'C:\Data\SID\'


1

Ok, I didn't realise that creating such an export file consists of two steps. First, an ordinary dump file must be created, then this dump file is used to create an sql file. Since I didn't have such a dump file, the script as posted would not work. Here are the two steps, so that an sql file can be created declare datapump_job number; job_state ...



Top 50 recent answers are included